table

Embedding PowerPoint Chart into Excel

Hey guys! I always get great answers here, so here is another question (this one may be simple, but I don't know if/how...). If I embed a PowerPoint Presentation within an Excel Worksheet, then, within the ppt, set up chart objects on each slide, can I go into the data table for the chart object, and have it refer back to the excel spre...

What’s the correct scope value to use for an HTML th table cell than spans several columns?

Say you’ve got an HTML table, with a th cell that spans several columns, e.g. <table> <tr> <th colspan="3" scope="?">Scores</th> </tr> <tr> <th scope="col">English</th> <th scope="col">Maths</th> <th scope="col">Science</th> </tr> <tr> <td>12</td> <td>16</td> <t...

tab view in css with tables

I need a tab view in css with each tab showing a dynamic table. The complete table is dynamically constructed in loop and only after that should the tabs should hide and show each of the table corresponding to each tab. Any suggestions? The content of the tab is within list item and in loop only. The development is in Django/Python on ap...

MySQL FULLTEXT indexes problem…

So I’m trying to create a FULLTEXT index on an attribute of a table. Mysql returns ERROR 1214: The used table type doesn’t support FULLTEXT indexes. Any idea what I’m doing wrong? ...

Refresh Routing Table on Windows 2003

Is it possible to refresh the routing table on a server running Windows 2003 without a reboot? If so, how? ...

Stop continuous table generation

Hello, I am trying to stop the data in the following table from continuing to repeat itself, as in looping on the same data, crashing the browser: Here's the query: $posts = mysqli_fetch_assoc(mysqli_query($db, "SELECT * from tbl_bugresponse WHERE bugid = $id ORDER BY time")); And here's the table code: <table width="100%" class="tb...

How can I sort by column header if clicked on and then sort in reverse order when clicked on again?

I have a table of data that is dynamically being brought in with PHP. I have two Column Headers - Name and Price I am looking for a php script that lets me sort the data by clicking on one of the Column headers, and then when the user clicks on it again, I want it to sort the data in the reverse order. Or if the user clicks on the other...

MySQL table modified timestamp

I have a test server that uses data from a test database. When I'm done testing, it gets moved to the live database. The problem is, I have other projects that rely on the data now in production, so I have to run a script that grabs the data from the tables I need, deletes the data in the test DB and inserts the data from the live DB. ...

how to remove all inherited CSS formatting for a table?

I have a table which has a certain style due to the css file for the page (it has blue borders, etc...). Is there a simple way to remove the css for that specific table? I was thinking something along the lines of a command like style="nostyle" Does anything like this exist? ...

Inserting multiple rows in SQL

How do I restore my data from a backup table table1_bu into a new table new_table1, which has the same structure? I need to insert all the rows from table1_bu into new_table1. ...

Hibernate error: cannot resolve table

I'm trying to make work the example from hibernate reference. I've got simple table Pupil with id, name and age fields. I've created correct (as I think) java-class for it according to all java-beans rules. I've created configuration file - hibernate.cfg.xml, just like in the example from reference. I've created hibernate mapping for...

fullscreen layout

Having a world of trouble with a fullscreen layout. Either a table or css based solution would be appreciated. The goal is to expand to the viewing screen, with the "nav" fixed by width and "top" fixed by height, ideally without javascript. The code below works until the "content" fills up. When that happens it needs to scroll. However,...

Concatenating rows from different tables into one field

Hi! In a project using a MSSQL 2005 Database we are required to log all data manipulating actions in a logging table. One field in that table is supposed to contain the row before it was changed. We have a lot of tables so I was trying to write a stored procedure that would gather up all the fields in one row of a table that was given t...

jQuery .toggle() not working with TRs in IE

I am using jQuery's toggle() to show/hide table rows. It works fine in FireFox but does not work in IE 8. show()/hide() work fine though. slideToggle() does not work in IE either - it shows for a split second then disappears again. Works fine in FireFox. My HTML looks similar to this <a id="readOnlyRowsToggle">Click</a> <table> <...

SQL simplify a characteristic function? or PIVOT tables?

I have this a Table with a bunch of dates and prices: Room Name, Price, Bookdate, etc And I can transform it like so: (which essentially flips the columns) SELECT availables.name, rooms.id, MAX(IF(to_days(availables.bookdate) - to_days('2009-06-13') = 0, availables.price, '')) AS day1, MAX(IF(to_days(availables.bookdate) - to_days...

Sorting of 2D array rows in jquery

Hi folks, I have a table which have to sort with expanding and collapsing of row groups. Because this i am using 2D array. The way of DOM selection or some other regions its execution time is bad. I appreciate your response. Table image $.each(myData, function(index, row) { $.each(row, function(index1, row2) { row2.sortKe...

database view performance issue

Hello everyone, I am using SQL Server 2008 and I have two tables which are of the same schema and I create a view which union the content of the two tables to provide a single view of "table" to external access. One of the table is read only and the other table contains bulk insert/delete operation (on the other table, I will use bulk ...

MySQL Error 1 (HY000) Trouble creating file Errcode 2

Hi everyone, I'm having issues creating a table for my ruby on rails app. It's driving me crazy! The following is returned when I try to create the table: ERROR 1 (HY000): Can't create/write to file '/usr/local/mysql/data/test_development/users.MYI' (Errcode: 2) It's worth mentioning I'm a total newbie, btw. ...

jQuery dynamic table live click plugin

I'm trying to write jquery-plugin for table. I have 2 dynamic tables from server: <div id="first_column"> <table> <tr id="f1"> <td class="select">some text</td> <td class="name">some name</td> </tr> <tr id="f2"> .... more same rows .... </tr> </table> </div> <div ...

Dbunit ant task export: Exclude tables

Is it possible to say dbunit export all tables except the list (I'm using ant for the purpose)? ...