table

jQuery conditional selector for table rows

I have a table with data in: <td> item </td><td> order code </td><td> price </td> I'm processing the table with jQuery which needs to find the order code: $.each($('.productList tbody tr'), function() { var orderCode = $(this).find('td:eq(1)').html().trim(); // do stuff }); If there are no products, the table shows a message...

Table Row, when add padding to one cell the whole row gets pushed down

I have a table, with some rows and columns, here is the example of the second row <tr> <td valign="top" style="width: 150px;"> <h5>MyCity</h5> </td> <td valign="top" style="width: 360px;"> <h5 class="store_title">Store Title</h5> <p>address</p> </td> <td class="storeDescriptionCell"><div>Descr...

LINQ to SQL using dynamic tables

I am developing application VS 2008, .NET 3.5 and I am trying to use LINQ To SQL. I drag & drop tables on the designer to generate the .dbml file. The problem I have that I have some dynamic tables for search indexing. I know the structure of table, only the application creates new tables like this: Files_1_1, Files_1_2, ... Files_m_...

Update mySQL table based on row=column name

A little background so you understand what I'm trying to do. I am making a page that takes two user input products and checks to see if they are compatible with one another. This is an n+1*n mySQL table because there are n products. The table looks like name a b c d e a b c d e I already know that every product is comp...

Need help with XML/XSL table formatting

Let's say I have a list of 500 names in XML tags. I want to display this list in a table using XSLT. In the XSLT table I want to have a maximum of three rows; I don't care how many columns I have - I plan to put the table into a scrollable div. If my list of names grows to 1,000 I still want only three rows, but the amount of columns ...

Querying multiple tables

Hi there. Following on from my query yesterday, I've restructured my recipe database as follows: categories cid | category_name 1 | desserts 2 | cakes 3 | biscuits recipes id | recipe_name 1 | black forest cake 2 | angel cake 3 | melting moments 4 | croquembouche 5 | crepes suzette ingredients iid | ingredient_name 1 ...

Finding the optimum column and row size for a table with n elements and a given range for its proportion

I am looking for an optimum way to create a table from n elements so that ideally there are no empty cells, but at the same time the proportion of the table dimensions colums / rows becomes as close to 1 as possible. Of course if n is a square number it is easy since then cols = rows = sqrt( n ); If n is a prime number it is also cle...

JQuery add delete row table from another

I have two tables with FIRST and SECOND id. <TABLE ID="FIRST"> <TR> <TD></TD> <TD></TD> <TD></TD </TR> </TABLE> <TABLE ID="SECOND"> <TR> <TD>1</TD> <TD>First Value</TD> <TD><A HREF="#">Add</A></TD> </TR> <TR> <TD>2</TD> <TD>Second Value</TD> <TD><A HREF="#">Add</A></TD> </TR> <TR> <TD>...</TD> <TD>...</TD> <TD><A HREF="#">Add</A></TD>...

Outputting multiple results from tables

The recipe db continues... categories cid | category_name 1 | desserts 2 | cakes 3 | biscuits recipes id | recipe_name 1 | black forest cake 2 | angel cake 3 | melting moments 4 | croquembouche 5 | crepes suzette ingredients iid | ingredient_code | ingredient_name | ingredient_brand 1 | abc201 | self-ra...

Python Reportlab RML. How to split table row on 2 pages.

I'm wondering if there is some functionality to split table row on 2 and more pages. Cause some information in row can be too long for one page. And if one row longer then page size then it's cause an exception. ...

How to display Different tables or blocks of data on the same row (level) in HTML

Dear All, I need to display some data on a browser but I want to split the page into two sections. Thus I want to show the second table next to the other rather than below it. Do you have any idea? ...

Table design for a matching system

How would I design the tables for a matching system doing something like this: We have X products which can have Y properties. The number of properties can vary from product to product and two products doesn't have to have any similar properties. My number one goal is to take one product and find the most similar product. Normally I w...

HTML table empty on postback in aspx page in IE 7/8

I have some .aspx pages that are displaying an odd behavior in Internet Explorer 7 & 8 (but not Firefox). I am using master pages. The page has a table with a large number of dropdowns, textboxes and radio/checkbox lists, plus two gridviews. Some of these controls have autopostback and, when the page postsback, the table is empty on t...

Html Tableless form

I have a section of an html page that I want to display in a table-like way. I keep hearing not to use <table> for layout. And I get the general reasoning. 1) mark up becomes bloated, so it takes longer to download, 2) a table is rendered all at once(so it might delay loading until all of it is read) 3) probably a myriad of other rea...

redundant column

Hi there, I have a database that has two tables, these tables look like this codes id | code | member_id 1 | 123 | 2 2 | 234 | 1 3 | 345 | 4 | 456 | 3 members id | code_id | other info 1 | 2 | blabla 2 | 1 | blabla 3 | 4 | blabla the basic idea is that if a code is taken then its member id field is fil...

How to save a ado recordset into a new local table in access 2003?

I'm trying to import tables from a FoxPro 9.0 database into access 2003. So far, from google searches and many trials, the only way for me to connect to the tables is through an OLE DB connection programatically. I have set up 3 ODBC connections with different configurations but none of them work. I get unspecified errors, that I can't f...

Table attribute width is ignored

Hey, I'm working on a "little" software project for work. The goal is to generate a html file with tables and export them into pdf. Unfortunately I cant get the table to act like I want. One part of the table should display a timescale with days on the lowest row, weeks,months and years are in the rows above an have a pre-calculated ...

IE8 ignores td width, works on IE7

Greetings, I've been trying to make a site work for half a day to no avail. IE8 is bad for my mental state. So, there is a table looking like this: <table width="100%"> <tr id="header"> <td colspan="2"></td> </tr> <tr id="center"> <td id="left" style="width: 201px"></td> <td id="mainpage" style="width: 100%"></td> </tr> </table> ...

find previous element of a table using jquery.

I have a HTML table with following content. <table class='main'> <tr id='r1' class='tbl'> <td>V1</td> </tr> <tr id='r2' class='tbl'> <td>V2</td> </tr> <tr id='r3' class='tbl'> <td>V3</td> </tr> <tr id='r4' class='tbl'> <td>V4</td> </tr> <tr id='r5' class='tbl'> <td>V5</td> </tr> </table> I can select a row by using...

Help forming a complex SQL statement

Hello friends! I'm coming up stumped on forming a working SQL statement for a project of mine. First of all, I have a "questions" table and a "response" table. The response table is tied to the question table through a foreign id called "question_id" (tied to the questions "id"). A question doesn't necessarily have to have a response, b...