table

Can I extract Tables from PDF using Perl?

I need to extract table objects from PDF documents preferably programmatically using Perl. I am able to cut and paste to Excel, but the table would require quite a bit of manual editing once the data is imported into Excel. I've done some search, but so far it seems though most forums suggest that most APIs are very primitive. ...

Is it possible for an SQL table to have zero columns?

I'm using the following query to gather information about a table's columns: SELECT COLUMN_NAME, ORDINAL_POSITION, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, Is_NULLABLE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TableName' ORDER BY ORDINAL_POSITION If this query returns zero results, can I s...

Multi-sort Media Wiki Tables

Hello, I am trying to allow sorting a wiki table that use the "sortable" class by multiple columns. Eg: {| class="wikitable sortable" |- |Col 1 |Col 2 |Col 3 |- |3 |a |tee |- |2 |c |hot |- |5 |b |apple |} That will give you a basic sortable table on the wiki, but it won't let you sort by multiple co...

Combining Rows in Javascript

Hi, I'm looking for some help on the javascript angle of this problem. I have a table that goes like... <table> <tbody> <tr> (Row 1) <td colspan="3"> <p>This Says Something</p> </td> </tr> <tr> (Row 1a) <td> <select option> </td> </tr> <tr> (Row 2) <td colspan="3"> <p>This Says Something</p> </...

jquery: trying to "sync" 2 html tables (apply column widths)

hi, i'm having 2 tables: table1 (the "header-table", which only has 1 row with table columns) - and table2 (the "data-table", which has several rows with all the data). table1 has widhts assigned to most columns. i'm now trying to apply the column widths from table1 to the 1st row of table2 (table1 has same width as table2). my code i...

JSF Command button inside a JSF data Table

I am using a JSF data table. One of the columns in the table is a Command button. When this button is clicked I need to pass few parameters (like a value of the selected row) using the Expression language. This paramaters need to be passed to the JSF managed bean which can execute methods on them. I have used the following snippet of c...

Database Table Update Error on NULL Value

Hello everyone, I have a two tables. One table is actually populated by daily events while the other is just a summary of the other table. I have a stored procedure which deletes the values stored in the Daily Table. Now every after delete, the Summary table should also be updated such that the SUM will now be updated less the value of...

how to cache latest inserted data in MySQL?

Is it possible to cache recently inserted data in MySQL database internally? I looked at query cache etc (http://dev.mysql.com/doc/refman/5.1/en/query-cache.html) but thats not what I am looking for. I know that 'SELECT' query will be cached. Details: I am inserting lots of data to MySQL DB every second. I have two kind of users for ...

C# - Best way to store sets of data (In a table)

I have a client and a server program, and I am currently using hashtables to store the clients Name and ip address when they connect. I now need to add another variable that the client will send to the server when it connects, but as far as I understand it, hashtables only have 2 columns (Key and value). Is there another way I could stor...

How to update a record from database via ADO.NET Entity Framework?

Hi, My WPF desktop-based application uses ADO.Net Entity Framework in order to connect with SQL Server database. In one of the windows I have a DataGrid with all data from tbl_users, when user selects one of the row (record) and clicks on Edit, application opens a new window with form, that includes all data that user can edit/update. ...

Add table elements from array of objects using jQuery

I know that given enough time I'll figure this out, but it sure would be nice if some kind soul can point me in the right direction. I am relatively inexperienced with jQuery, but I have somewhat intermediate javascript knowledge. Given an array of objects in the form: [ {"value1":"10/14/2010", "value2":"1", "value3":"1178.94"}, ...

Latex error: extra alignment tab has been changed to \cr

I am using ACM SIG template and trying to create a table of 4 columns. I get the error mentioned in the title of the question. I know the standard reasons why this error can occur. But my question is:- Is it possible that the template or .cls file is controlling the maximum number of columns in a table ? It it were, would I get a dif...

a way to make adding and removing classes on a table faster?

I have a large table with 27 columns and between 5 to 100 rows. I have mode switch (checkbox) that switches the view of a table from the first 5 columns (simple) to 27 columns (expert) and back. Currently I use the following jquery method to switch between the modes: $("#ToggleTableCells").click(function(){ if($(this).is(':checked...

<span> tag breaking row in IE7

Hi! My code is as follows: <table> <tr> <td><div id='lunch'><a href='Lunchplace.aspx?c=1&id=110'><img style='margin-top: 3px;' src='./images/115x52_Brasseriet.jpg'class='imagealign'/><b>Brasseriet</b><br />Köttbullar med gräddsås & kokt pota...&nbsp;<span style='color:#f29400;font-size:small;float:right;'>80 Kr<span style='float:right;'...

horizonal and vertical alignment of div

I am using JQuery. I have a div that contains a table. I have 4 rows in the table each with one col. Each row contains a line or two of text I want to make each row with height = 100 px and have the text centered horizontally and vertically. can this be done? Thanks! ...

Grails: How do I create filter like the ones in MS Excel??

I want to sort the elements in my list and have the option of filter them the same way MS Excel does. So it should be able to keep the filtered elements in the table and apply a filter within those results as well. Also be able to sort them without refreshing the whole table. Any help is greatly appreciated! FG ...

select second largest from a table without limit

How we can select the second largest mark or whatever from a table without using the LIMIT ? I know it is possible using LIMIT, but is it possible without using that? suppose we have the columns id and marks. ...

HTML table rowspan or colspan issue?

We need to design a webpage layout. Using table we can divide layout into six zones (cells) as shown below: ZONE 1 ZONE 2 ZONE 3 ZONE 4 ZONE 5 ZONE 6 Now, it is possible to merge ZONE 2, ZONE 5 and ZONE 6? We need to use DIV? ...

Resizable table columns

Hi I'm developing a web app and am looking for a way to create my own datagrids. I know that there are lots of fantastic scripts out there with all the bells and whistles, but I need my own specific functionality, css styling, and the ability to use my own ui controls in it. Really, the only thing I need is the ability to resize the co...

how to read lua table return value from c++

hi, I have a lua function that returns table (contains set of strings) the function run fine using this code: lua_pushstring (lua, "funcname"); lua_gettable (lua, LUA_GLOBALSINDEX); lua_pushstring(lua, "someparam"); lua_pcall (lua, 1, 1, 0); the function returns a table. how do I read it's contents from my c++ code? ...