table

Loading a lookup table from a database into a C# program - data structure?

I have a table full of id's,categories and weights that I need to reference in my program as I read in records that contain those categories. What is the most efficient method to read those from a database and put into a structure that I can reference? The ID's (and possibly the names) would be unique Data might look like: ID,Category...

Search for an item in a Lua list

If I have a list of items like this: local items = { "apple", "orange", "pear", "banana" } how do I check if "orange" is in this list? In Python I could do: if "orange" in items: # do something Is there an equivalent in Lua? ...

table to horizontal bar graph in jquery

I cannot really tell more I have a table 1-joe-234 2-bob-432 3-sean-654 i like to take it and get a bar graph with it Not that there is no lib on the net, but is prototype or flash xml file -- the solution i am working on, is a jquery plugin that will generate a html link for google chart... not pretty but KISS (really simple) and...

How many rows of data is too many rows of data?

Is there some hard and fast rule about how big is too big for a SQL table? We are storing SCORM tracking data in a name/value pair format and there could be anywhere from 4-12 rows per user per course, down the road is this going to be a bad thing since there are hundreds of courses and thousands of users? ...

How do you assign a column default in MySQL to another column's value?

I want to add a new column to a table in MySQL database that should get the value of another column in the same table. Is this possible? If so, how do you do it? Thanks! ...

How to get a cell's location

I'm writing a script which manages a very large table. When a user clicks a table cell, I would like to know which cell they clicked. e.g -------------- | | | | | Click| -------------- should give me a cell reference of (1, 1). Any way I could do this with javascript. The page it's running on uses jquery for other purpos...

Tables looking good in Firefox but not IE

Hello, First time question here. I have a site that I built around tables, I know not good, but it has been done. It looks fine in Firefox, but the text is all over the place in IE. Link is http://www.mothershipinc.com Warning: contains music Here is the code for the index page: <?php include "db.php"; function imageResize($width,...

HTML Table Rows

What is the best way to turn off the visibility of a row(s) and have the gaps removed. Also the reverse, if turning on the visibility making sure that the visible row(s) are displayed again. Thanks ...

Parsing an HTML table using Hpricot (Ruby)

I am trying to parse an HTML table using Hpricot but am stuck, not able to select a table element from the page which has a specified id. Here is my ruby code:- require 'rubygems' require 'mechanize' require 'hpricot' agent = WWW::Mechanize.new page = agent.get('http://www.indiapost.gov.in/pin/pinsearch.aspx') form = page.forms.find...

Border around specific rows in a table?

I'm trying to design some HTML/CSS that can put a border around specific rows in a table. Yes, I know I'm not really supposed to use tables for layout but I don't know enough CSS to completely replace it yet. Anyways, I have a table with multiple rows and columns, some merged with rowspan and colspan, and I'd like to put a simple border...

JQuery tablesorter + resizing column widths

I'm looking for a JQuery plugin for resizing table columns that works with tablesorter. Any recommendations? ...

How to stripe rows for a multiple row record using jQuery?

I am currently using the following jQuery script to highlight rows in my table, and it works great! <script type="text/javascript"> $(document).ready(function() { $('table.grid tbody tr:odd').addClass('alt'); }); </script> This works great for tables of data where each row is truly a new reco...

Special characters in LaTeX table caption

When I include \overline{x} or other special characters in the caption text of a table, the whole caption text won't appear at all. When I put simple text without special characters, the caption works fine. How can I include special characters in the caption? ...

why do square bracket appear with the table name?

Hi, I created a database with couple of tables and some table names are enclosed with square bracket: [table_name] Does anyone qnow why this happen, and how to get rid of it? Thanks! ...

Text running outside of its box in IE/Opera

Page: http://www.visitherefordshire.net/news In Internet Explorer 7 and Opera 9.6, the text is running outside the box. It appears to be due to the tables being 100% width: if I set a pixel width (e.g. 700px) then they fit. As far as I can see all the 'outer' divs are not wider than the visible box, so why does the 100% width on the ta...

table level backup

How to take table level backup (dump) in MS SQL Server 2005/2008? ...

connect tables with ODBC

to connect multiple tables in oracle with ODBC do we need to create different DSN for different tables ...

Using JQuery to update table cell content from an ajax call

Hi folks, something strange happens, when I try to update a table cell value with the returned data from an ajax call. Considering a Table like this <table> <tr> <th>header1</th> <th>Error Count</th> </tr> <tr> <td>useless data</td> <td><span id="cellToUpdate">244</span></td> </tr> </table> Within an JQuery A...

Data-centric web application design book/article recommendations

I am designing a web application that deals with lots of data. I find it difficult to present this data in a usable, intuitive way. The data has to be sortable/searchable, and the relationships between the data should be obvious (records can have "child items"). Are there any books that specifically deal with this? I am not looking for ...

HTML table with fixed headers and a fixed column?

Does anyone know a CSS/Javascript technique to display a long html table such that the column headers stay fixed on-screen and the first coloumn stay fixed and scroll with the data. I want to be able to scroll through the contents of the table, but to always be able to see the column headers at the top and the first column on the left. ...