table

regular html table border show up very strange in firefox

I created a html table and used this css to style the border as i wanted: the top row and column to be one color and the rest of the table to be stripes alternative row colors regular single black border over each cell Here is my css: #functionMatrixTable td { border-collapse: collapse; border-width:1px; border-color: Black; bor...

Impact of providing exact sizing for the page elements as opposed to the browser resizing tables

Hi we have a application of huge amount of data which is to be converted into HTML tables via Velocity templates.Question1: One area to be focussed is the impact of providing exact sizing for the page elements as opposed to the browser resizing tables height and width want to understand how much time is spent by the browser doing that as...

Can div really override table for everything on layouts?

Hi Maybe there is already a question about this subject, but I couldn't find it. My question is simple, Can I use only divs on a page layout? I got myself in trouble to create a div with corners for example. A_____B______C | | D E F | | G_____H______I take all letters as divs with some background,...

How can I do a compare when the second is a sub select that returns multiple values?

Here's my SQL statement: SELECT DISTINCT a.* FROM OWU_Nomination as a, Merchants as b WHERE a.CallFlag = 'False' AND a.nominatedDate < DateAdd(hour, -24, getdate()) AND a.email != (SELECT c.Email from Members as c where c.MemberID = b.MemberID) The problem here is that the sub select after a.email != returns multi...

optimize asp.net c# code for repeaters using a table

on the aspx: <table> <tr> <asp:Repeater ID="rptHeader" runat="server"> <ItemTemplate> <th><%#Eval("Category")%></th> </ItemTemplate> </asp:Repeater> </tr> <tr> <asp:Repeater ID="rptContents" runat="server"> <ItemTemplate> <td valign="top"> <%#Eval("Content")%> </td> </ItemTemplate> </a...

How to convert Table base design to Table less design page

Hi, In my website there is table base design. And i want to convert it into tableless (Div, span, etc). Is there any Tool which will convert this automatically. Thanks in advance ...

CSS background-color on table td displaying incorrectly in Internet Explorer 6

I have some pretty simple HTML and CSS that doesn't work in Internet Explorer 6. <!DOCTYPE HTML> <html> <head> <style> table td.one.read {background-color:#FFD700;} table td.two.read {background-color:#0000ff;} table td.three.read {background-color:#ff8c00;} </style> </...

Joining SQL lookup table with data table

I have a lookup table say cities with fields CityId, CityName CityId CityName 1 New York 2 San Francisco 3 Chicago I have an orders table which has fields: CityId, CustId, CompletedOrders, PendingOrders CityId CustId CompletedOrders PendingOrders 1 123 100 50 2 123 75 2...

Log meta-data to be part of entity tables or separate?

Hello. For entities in my application, I am planning to log common meta-data like DateCreated, DateModified, IPAddress, etc. Does it make sense to add these columns in entity tables or is it better to have a single table for logging meta-data where each row has link back to the item that it corresponds to? Later for purpose of reporting ...

iterate through rows in an html table with c#

I have an html table in an aspx page (C#) that has columns like 1.CheckBox 2.Text 3.Text 4.TextBox I want to iterate through the table one row at a time and process (run a stored procedure based on column2) based on whether the checkbox is checked or not. How will I be able to do that? ...

how do i create sub groups within table using jquery?

i am creating a stock portfolio. each row is a stock and it's data including profit/loss. each row has a groupid that the user can specify. the idea is i want to: 1) physically group the rows based on the groupid 2) after step #1 i want to dynamically add a row below that group with the subtotal of the profit/losses for that group on...

How do I display an array using XUL elements like a table in HTML

I have an array data = [{'name':'Bob','email':'[email protected]'}] How can I render this array using XUL elements (like a table in HTML)? I'm using pure javascript (do not using any JS framework) ...

Changing the Pivot Cache works fine except when 2nd pivot table is added

Hi, Using Code to change the pivot cache of the pivottable specifically: Dim pc As PivotCache, pt As PivotTable Set pt = Sheets("Sheet1").PivotTables("PivotTable1") Set pc = pt.PivotCache With pc .CommandType = xlCmdSql .CommandText = "Select * From Query1 Where Query1.Date BETWEEN #" & startval & "# AND #" & endval & "#" .Refres...

CSS, Selector, table

Hi, I have a question, I what to hide from CSS column number 2 and 4 from the table . Can I detect that columns from CSS. Thanks !! ...

Linq to SQL (views or tables)?

I initially thought that using a view would be the best option because I've already encapsulated every column that I want in it. However, after closer inspection, it seems that adding just tables (and using the built-in relationships that are already created) is a much cooler way to do it because those relationships cause LINQ to SQL t...

SQL Replacement via table

Mysql question: I've got a table A with a column full of sentences. I've got another table B with two columns: words and abbreviations. I want to look through table A's column sentences and if a word from table B's word column matches then replace it with abbreviation. Hope that is clear. Case doesn't matter, I can deal with that. ...

Organising Dbs and tables in SSMS

This is a repost of a question I asked 4 or 5 days ago, with zero response. Hoping for more luck this time... (Using SQL Server 2008) Hi Within the next few weeks I plan to introduce SQL server to an office that is in dire need of a proper data server. Currently there is a heavy reliance on loose Excel and Access file (supplemented wi...

Table grid control for ASP.NET

What is the best way for me to build a control that will kinda work like an Access table in ASP.NET? That is, I define, say, 3 columns. The user can add/edit/remove rows. It can be one row at a time, that's fine. There are other fields on the form too, not related to this table. When the user is done adding rows of information, then...

Help defining tables/Primary Keys

I'm designing a database for a franchiser. My skill level is intermediate at best (I just work in the franchiser's office). This database must define store locations and franchisees. So I know I will need a "store" table and a "franchisee" table. The "store number" will be the primary key in the store table. One franchisee can own mu...

Sorting a table in asp.net mvc

Hi all, I was wondering how people were going about sorting a table in asp.net mvc? I've heard of javascript solutions that work pretty well with non-paged tables, such as jquery's table sorter, but i need a solution that will work with paged tables. The project i'm working on currently uses the following solution, but i find it very m...