table

IE8 isn't resizing tbody or thead when a column is hidden in a table with table-layout:fixed

IE 8 is doing something very strange when I hide a column in a table with table-layout:fixed. The column is hidden, the table element stays the same width, but the tbody and thead elements are not resized to fill the remaining width. It works in IE7 mode (and FF, Chrome, etc. of course). Has anyone seen this before or know of a workaroun...

Border Collapse differences in FF and Webkit

I have a table with the following rules : <table cellspacing="0" cellpadding="0" style="table-layout:fixed; width:1000px;border-collapse:collapse;border-spacing:0"> and the cells have the following CSS: td{ padding:4px; height:22px; border:1px solid gray; } The computed style for my table cells looks like the following in FF: ...

Sorting table data across two table sets with jquery tablesorter

I am using jquery table sorter and have two tables. Instead of sorting the data just in the first table, could there be a way to combine the data in the second table and sort both? As an example, sorting column 1 on table 1 OR 2, will result in: //ORIGINAL //RESULT TABLE 1 TABLE 1 col1 | col2 col1 | col2 1 | 1...

Set inner table border in HTML

How do I set the "inner border" - the border between different cells. By setting style attributes I manage to control the outer border, but the inner border just stays the same gray color and the same width. What attributes should I tweak to control the inner border? ...

Information sent in an HTML form

Hi, I've a HTML file that shows to the user the contents of a database (it is shown as a table). The user can choose one of the rows.When this is done the selection made by the user is sent to a servlet that will work with that information. Imagine that this servlet is going to look for files related to the information chosen by the u...

Insert Query for table

How to add data from one table to another table with new data in sql ...

HTML align table rows on top

Hello, I have an HTML table. It looks as follows: <table> <tr> <td>Content one</td> <td rowspan="2"> Very long content right</td> </tr> <tr> <td>Content two</td> </tr> </table> As you see, I have some very long content on the right side of the table, actually, it is so long that it does not fit...

Why my tables' names are converted into lowercase in phpmyadmin ?

I am using wamp server 2.0 on Windows XP. Whenever I create a table with some uppercases in name, it is converted to lowercase. For example: I create: UserInfo phpmyadmin convert it to: userinfo I am using ubuntu/phpmyadmin in office but this problem does exists there. from where can I fix this. Thanks ...

HTML: how can you create a row/collspan like this? (example included for clearity)

i want a specific sort of coll span like this C stands for Row/Coll-spanned |-------| | | C | |-------| | C | C | |-------| for more clarity this is the code of a simple coll-span and image <table> <tr> <td colspan='2'> </td> </tr> <tr> <td></td><td></td> </tr> </table> gives |-------| | C | C | |-------| | | | |-------...

What command is used in mysql to look at the table and give tips?

I seem to remember that there is a command to look at a mysql table and let you know things like maximum size of strings and integers and such so you can optimize the size of your index/table. Do you know what that command is? G-Man ...

Applying changes easily in Access Database

I have got a bakcup of a live database (A copy of an ACCDB format Access database) in which I've worked, added new fields to existing tables and whole new tables. How do I get these changes and apply that fastly in the running database? In MS SQL Server, I'd right-click > Script Table As > Alter To, save the query and run it wherever ...

Latex: Listing all figures (tables, algorithm) once again at the end of the document

Hi all, I have been writhing a rather large document with latex. Now I would like to list all the figures / tables / algortihms once again at the end of the file so that I can check if they all look the same. For example, if every algorithm has the same notation. How can I do this? I know about \listofalgorithms and \listoffigures b...

After Trigger execute before constraint check in oracle

Hi, I have After Insert/Update trigger on Table T1 which get the referential data for Col1 from T2 and does some work and insert it into another table. The col1 is FK to Table T2. When user insert the incorrect or non existing value into the Col1 and if trigger is disabled I am getting constraint error that is fine. But when trigger is...

Need compare tables utility for SQL Server

Command line or library "compare tables" utility for SQL server with comprehensive diff output to a file in .Net I can't find anything like that. Commercial or free ( XSQL Lite is suitable for my case and ) tools show diffs in grids with possibility to export to CSV. Also they generate sync SQL scripts when run from command line. Wha...

Rails: Specify a table prefix for MySQL

In CakePHP, I can specify a prefix in my database configuration, f.e. "so_", so that every model looks for its table under this prefix. Is something similar possible in Rails, too? That is, can several programs share one database? ...

MYSQL updating data from other table

Hi, I have two tables like of this structure content (content_id, content_type, user_id, time, comment_count) comments (comment_id, content_id, userid, comment, comment_time) What I wold like to do is update the comments_count field with sum of comments i.e COUNT(content_id) from the comments table. I am not able to figure out the r...

table cell and row borders different on each edge in C#

I'm trying to dynamically generate a report in a table where the borders are different on each side of a cell or row, but can't figure out how. The TableRow, TableCell, and Table objects each have a BorderStyle property, but it seems to apply to the entire border rather than just one side. Can this be done without nesting tables? For ...

Keeping a certain row or column in an HTML table fixed

I have huge amounts of data populating an HTML <table> having more than 200 rows and 200 columns. However, when i scroll the page horizontally or vertically to view the data, the header columns (like th for instance) go beyond the page. How can i scroll through the table and still keep the top row and leftmost column fixed so that i wi...

hidden row causing issue with tablesorter zebra striping

Sorry if this has already been solved elsewhere but my searches have been able to turn up nothing and my attempts at solving the issue myself have made even less progress. :P Put quite simply I have a table that is using the jquery tablesorter and it's zebra widget. In this table there is a hidden column. I've so far been able to make i...

Problem with Workbook Events and reading Table Objects

Hi, I am working on an excel workbook add-in where I'm supposed to add a menu item to the ribbon which I already done. I have to enable this menu item when the user clicks on the table object in the worksheet. Can anyone please tell me what event should I use to achieve this and how to find out of the current cell is part if a table ob...