table

jQuery star rating in a table

Hi, I have an MVC application generating a series of radio buttons based on a dynamic set of questions. The questions are generated, and the star rating works perfectly, but for some reason, when I try to have each radion button in its own cell in a table, once the javascript kicks in, all the radiobuttons appear in just one cell. Wit...

How to rename a column in SQL?

What is the best practice when it comes to renaming a table column using SQL (MS SQL Server 2005 variant)? This assumes that there is data in the column that must be preserved. ...

jquery tablesorter and select all checkbox in table header

I have a table with a "select all" checkbox as the first header column and some simple code to select all checkboxes on the page when the header checkbox is clicked. $('#CheckAll').bind('click',function() { var checked = $(this).attr('checked'); $('input').attr('checked', checked); }); the code runs fine, but as so...

CSS - Border only inside the table

I am trying to figure out how to add border only inside the table. When I do: table { border: 0; } table td, table th { border: 1px solid black; } The border is around the whole table and also between table cells. What I want to achieve is to have border only inside the table around table cells (without outer border around the...

Make a multi-column table from a CSV file using PHP

Sorry if this is a bit long, but I want to be as detailed as possible. Basically, I'm trying to create a multi-column table from a CSV file using PHP. I would like the table cells to list vertically. For example, if I have a CSV file with the names: bill mike sarah steve kim dave Assuming I need 2 columns, I would like the table to...

Data add query in sql table

How to add new data(multiple rows) in sql table without deleteing existing data. My table is id Location Name User ID LogDate LogTime 1 Mumbai Shanks 0001 11-Aug-09 15:15:20 1 Mumbai Shanks 0001 11-Aug-09 15:25:28 1 Mumbai Shanks 0001 11-Aug-09 16:35:56 2 Delhi Mahen 0002 11...

How do I use a temp table across multiple c# calls.

I have a C# application, using ADO.Net to connect to MSSQL I need to create the table (with a dynamic number of columns), then insert many records, then do a select back out of the table. Each step must be a separate c# call, although I can keep a connection/transaction open for the duration. ...

foreach loop question with datatable

i have a data table and i want to write a loop where i can render a html table and i want to do it from scratch (not abstracted data sources) i want to have the number of items per row a variable. what is the correct loop syntax given a datatable with X number of records where each record is one cell. so if i have 20 records and my Nu...

Generating JSON Object

I'm trying to parse the rows in a table that I generate using javascript by adding items to a cart and then create a json object when the user hits save order of all the items and pass it to a php script using $.post in jQuery. The only trouble I'm having is understanding JSON objects and how to push more items onto the object. I get an...

Manipulate standard table with thead and tbody tags - to be later able to filter and sort

Hi there, I would like to modify a table that is generated by a wiki. This is why it has NO thead and tbody tags. What we try is to add these tags at the correct positions. Remember, the table itself is generated by awiki which means that lines can be added after a while. Here is my code (html and dojo): <script type="text/javas...

Override Inherited CSS Height

I have a style defined for tables. I then have a .tablestyle th { height:26px }... I now have a need to have a particular (one not all) th in the table auto determine its height. <table class="tablestyle"> <tr><th>Normal Stuff</th></tr> <tr><th>Long Stuff</th></tr> </table> The long stuff th needs a height of x, where x > 26px, but ...

jquery - go to next table row based on class name from current row location?

I can get the current row using this code. The "this" is a link in a table cell in the row. $currentTR = $(this).parents('tr'); These next two lines can do the same thing, get the tr after the current row. $nextTR = $(this).parents('tr').next(); $nextTR = $(this).parents('tr').next('tr'); If I output $nextTR.html() I see what I...

Lua - merge tables?

I need to merge two tables, with the contents of the second overwriting contents in the first if a given item is in both. I looked but the standard libraries don't seem to offer this. Where can i get such a function? ...

How do I link one table two times to another table using cakePHP

Hi I'm trying to set up a social networking type of site, where users can have friends and send each other messages. I have a users table, and a friends table, which basically has an user_id and user_friends_id. Using cakePHP, how can I link the user_id and user_friend_id back to the users table? I used bake to create all my models and...

html table - by rows or columns

do all browsers support html table by columns first. i know you can do: <table> <tr> <td></td> </tr> </table> but can you build up a table by columns first? Is there anything wrong with doing cols first? ...

Copy blob data from one table to another on MySQL

I need to copy a set of data from one table to another that includes a BLOB column. I'm using an INSERT query with a subquery SELECT: INSERT INTO dest_table(field1,field2,field3,blobfield,field4) (SELECT t.myfield1,t.myfield2,t.id,t.blobfield,'SomeConstant' FROM tablename t) All fields get copied correct, except the BLOB. I know I'm m...

How much table overhead is too much?

I just saw in phpMyAdmin that one of our MySQL tables is 14MB in size, but has 10MB overhead. I'm guessing this is a lot! How much is too much? Should I run OPTIMIZE TABLE regularly? ...

SQL - Reference current row

Hello I have the following tables : TableA ID | SomeInt 1 55 1 66 2 77 TableB ID | OtherInt 1 ComputedBy Field 2 ComputedBy Field The computed by field needs to return the sum from tableA where TableB.ID = TableA.ID, but if I say: SELECT SUM(SomeInt) from TableA where ID = TableA.Id where the first ID would be ...

Are tables replaced by DIVs?

Possible Duplicate: Why not use tables for layout in HTML? I know everyone is all about DIV's and css and against tables now days, I have always used tables because they are so easy for me to visually see what I am doing while building, I am just now ventruing into the DIV world. So my question are tables completely replaced by...

set colspan dynamically with jquery

Hi there, I have a simple table structure like this. What I would like to do is to dynamically merge some columns based on some condition within the for example, if td1 and td3 are empty then merge the cells and do <td class="col1" colspan="3">1Meeting</td> I tried playing around with jquery using $(".tblSimpleAgenda td:contains('...