table

Fixed position table header relative to parent scrolling DIV element

Hi, I need a fixed position thead that is static when the parent DIV element is scrolled. I don't need a scrolling tbody element as the parent will take care of this. Not fussed about IE6 support. The HTML: <div class="scroll"> <form method="post" name="price_update" id="price_update" action="/"> <table summary="A ta...

Using jQuery to add class to first TD on each table row

Hey folks, I have a table I'm working with that is like such: <table width="100%" border="0" cellspacing="0" cellpadding="0" id="tablecontent"> <tr class="tablerow"> <td>This is the td I want to add a class to.</td> <td class="cell2">Stuff</td> <td class="cell3">Stuff</td> </tr> <tr class="tablerow"> <td>This is th...

HTML 2x2 table: I want the first row is not divided in two parts.

Hi, i have an HTML table 2x2. In that table, I want the first row is not divided in two parts but only has one cell that occupies the full width of the table. ------- | | ------- | | | ------- How can i do that? Regards Javi ...

Lookup tables for basic user input?

Data like Birth month, day and year, user's age, Gender/Sex, etc. Should these be stored as text or ID based in database? ID based means they will have lookup values. Usage is for example: User signup will record age, user profiles will have a seeking partner age, etc so age and other data can be used in multiple places. In backend there...

Microsoft Access SQL query matching names unexpectedly

Hey all, I tried using Access for queries and it returns extremely unexpected results (where it would return records from contacts table that didn't even appear in the temp_query: SELECT contacts.names_1, contacts.names_2, contacts.addresses, contacts.cities, contacts.us_states_and_canada, contacts.zip_codes FROM contacts, temp_query...

Do all join tables have tables?

For example I have a comments models, and I have a post model, but comments can comment on other comments. So it seems I need a join table I'll call commentables. To create this, do I really need to create a commentable table with a post_id and a comment_id ? Or can I do something like this without one : has_many :comments...

Modelling a price matrix table in MySQL

Hello good people of stackoverflow, I am trying to create an ecommerce product that takes orders for print jobs. I would like to create tables such as the ones here on solopress for example http://www.solopress.com/leaflet-printing/leaflets.html. I am just struggling a little with the logical steps of modelling this in a database. Firs...

R Programming: Merging two variables to create frequency table

Hi again all, I have another newbie question; lets say i have a set of numbers graph_val <- c(4,2,3,4,1,1,9) and i need to create a frequency table of them against this scale 1 2 3 4 5 9 "Very Poor" "Poor" "Average" "Good" "Very Good" "Don't Know" ...

Programming a Savings Account Java Table to show an increment of 2

Hello guys! I'm working on a network application for my class. Basically I have to write java and jsp to make a site that gives the .jsp output below (which is preceded by a .jsp page that asks for the balance, rate, and period). I'm writing the java for it now and I'm trying to make a html table with the java class. The problem I'm ...

Rowspan with iTextSharp doesn't work properly

Good day, I'm trying to create a simple table with iTextSharp, so with c#. The goal is a table like this one: http://i.imgur.com/US8N3.png The problem is that if I apply the rowspan as 2 on cell A, iTextSharp does not render the rowspanned cell, this means that the cell have the same height of cell B. Here's the code: PdfPTable co...

Set width of td depending on No of td using jquery

I have several web pages with different amount of tables with different amount of columns. I was looking on the net for a jquery spinet which gets the number of columns of the table and depending on the number of columns will define the width of each column. Ex. if (noOfTdOnTable == 2) { tdWidth = "50%"; } if (noOfTdOnT...

What's the best way in javascript to delete row from html table? Table's td contains colspan and rowspan more 1 and it is a problem.

What's the best way in javascript to delete row from html table? Elements contain colspan and rowspan more 1. Function deleteRow() in DOM doesn't take into account colspans and rowspans. ...

Using sql tables with the same name on different schemas

Hi, Does anyone know of any white papers available that discuss the use of tables with the same name existing on different schemas? I'm implementing on SQL Server but I imagine the theory can be applied to any RDBMS. Thanks, Gary ...

is it possible retrieve 2 values from this code ?

a href="deleteresnext.php?rid=< ?php echo $row->rid ?>" onclick="return confirm('Are you sure you want to cancel reservation?');" >Delete can i retrieve 2 values using this code ? because i need it to another php file, i would like to retrieve rid and roomid by the code above ? need help urgent and thanks -renz ...

How can I access the table comment from a mysql table?

How can I get just the table comment from a mysql table? I tried the following, but they didn't work for various reasons. I want to figure out how to get just the string 'my comment' (ideally via perl =) Any help? -- Abbreviated output for convenience. SHOW TABLE STATUS WHERE Name="foo" +------+--------+---------+------------+------+...

Two different destination of submit in one form

Hello all, i have one form which need to submit data into two different tables in same DB. at past time, i have asked how to submit form into two tables, but it impossible. Then, I try to submit this form use two submit buttons with different destination. Could you give some advise to submit this form after click them? ...

How to increment a value of the table cells?

I can't understand how to increment a value of the table cells like: 1,2,3 etc? My code: $('#table').each(function(i){ $(this).find('td:nth-child(1)').text(i); }); Please, look at the full example ...

HTML table - fixed width columns and horizontal scroll

I need to create an HTML table which has fixed column widths, say 200px for each column. If the table exceeds the horizontal width of the browser viewport then there should be horizontal scroll to view the columns which are off-screen. As the table is being dynamically generated from a database there will be an indeterminate number of co...

delete table row javascript

Hi, everyone, I have created new rows, but I cant delete it. When I click on the remove button, nothing happends. What am I doing wrong? Im greatfull for any advice. <table> <tr> somethingElse </tr> <tr> <td colspan="5"> <script type="text/javascript"> var inputCount = 0; function addRow(id) { ...

Build temporary table with dynamic sql in SQL Server 2008

To make a long story short... I'm building a web app in which the user can select any combination of about 40 parameters. However, for one of the results they want(investment experience), I have to extract information from a different table and compare the values in six different columns(stock exp, mutual funds exp, etc) and return only...