table

Table scrollbar without changing headers and provide sorting in headers

Hello All, Here is mytable and need the headers to remain while there is a scrollbar only to the results and provide the sorting facility in the name. <table> <tr> <td>id</td> <td>name</td> <td>type</td> </tr> <% while(resultSet.next()) { %> <tr> <td><%=resultSet.getString...

SQL add tablename as field

I have seen this done before but i can't remember where i saw it. What i need to do is have the table name as a field in a query Say i have a table called users, how would i add the table name 'users' as a column like SELECT username, password, **table** as mytable FROM users ...

only show tables with certain patterns in mysql "show tables"

there are too many tables in a db. how can I only show tables with certain patterns? or is there a way I can do paging like "| more" in shell command ...

MySQL problem: Show on update

Hello! I wanted to know if its possible to display the contents of a mysql table on a page as soon as its contents are changed/updated Thanks! ...

Find location of a checkbox inside a table

I have a table that has checkboxes within tds. The checkboxes have ids that form an array (s[1], s[2], s[3], s[4], etc...) and I am trying to find out the numeric row location of the checkbox within the table>tbody (YES, this row location also matches the index inside the array. Here's the code I'm trying but the result is always "0": ...

Why does DbMetal Generate Table Attribute with "main"?

I'm a newbie with DBLink and Sqlite. When DbMetal generates Nortwind.cs (C#) it marks some methods with a Table attribute: [Table(Name="main.Categories")] // C# After I used DbMetal to create a Nortwind.vb (VB.Net) file, the test program aborted because there was no table named "main.Categories". However, when I removed "main.", it ...

Mantain table width fixed

I have a table with dynamic data. Depending on data,it expands or collapses. I dont want it.I want a fixed width that never expand or collapse. How can i do that? I've already try <table width="300px"></table> but doenst work ...

How do I control column width of the Vaadin Table?

I have a large table to display in one of our Vaadin application. The table has 110 columns with large text header for each column. On display the table looks awful as all the column header goes off the screen and the header separator loses the alignment with the data record column separator. I have set the table width to 100% to displ...

Difficulties while viewing the TD & TR

Hello All, I am having difficultied while getting the values into a table format: The previous format was: <table border="1" width="84%" align="center" bgcolor=#66CCFF bordercolor=#000000 height="137"> <tr> <td colspan="2" height="33"> <p align="center"> <span style="font-size: 8pt; font-weight:700">Name</s...

iPhone SDK: Opening a cell with a dedicated button, not by cell tapping.

I have a simple TableView containing several cells. Normally, I switch to selected cell details by tapping this cell. But what if I need a dedicated button for every cell? I've seen "Table View Cell" properties in Interface Builder, it has what I need, but it can't be added to existing cells. How to properly add this kind of button to e...

Error when inserting into SQL table with php

So this is my code: function function() { $isbn = $_REQUEST["isbn"]; $price = $_REQUEST["price"]; $cond = $_REQUEST["cond"]; $con = mysql_connect("localhost","my_usernam", "password"); if (!$con) die('Could not connect:' . mysql_error()); mysql_select_db("my_database",$con); $sql="INSERT INTO 'Books' (isbn, price, condition) VALUES ('...

What HTML tag is most appropriate for display in a Grid or Table? (with specific needs)

I'm trying to build a CSS-based table that will be populated with information coming from a database. What is the most appropriate tag to use for this structured data? I originally considered ul since each row is an unordered list of data... but then I uncovered some difficulties making it into a grid using CSS. I'm now looking at DIV...

MySQL Multiple Tables Link

Hi there I'm new to these types of MySQL Queries. Basically, I have two tables in a MySQL Database. One is called groupmembers and the other is called users groupmembers contains rows with two columns, a groupid and a userid users contains rows with also two columns, a userid and a username I am trying to write a query that searches t...

Programmatically Extract PDF Tables

Hi All, I have a bunch of PDF docs with tabular data in them which I need to extract into a more readable format to store in a spreadsheet, database or whatever. Is there anything out in the world (preferablly free) that is able to get tabluar data out of PDFs into a more readable format in bulk either natively integrated with an app o...

Trying to create a table in Struts2 from an ArrayList

Hi, I am trying to create a table to display some data I pulled out from a database into a JSP page (all part of a Struts2 application), and I don't know what I'm doing wrong here... This is the part of my JSP page where I create the table: <table> <s:iterator value="table" id="row"> <tr> <s:iterator value="row" id="...

How to preload tables into INNODB buffer pool with MySQL?

I have an e-commerce application that uses MySQL, and I'd like it to be faster. When a part # is accessed on the website that has been accessed before, the part loads quickly because all the necessary data is already in the INNODB buffer pool. However, if the part # has never been loaded before, that data isn't in the buffer pool yet, so...

Print in separate page javascript?

I am currently using php and getting complete user details and displays it into a html table. The problem that I have is when I print 3 tables each of them are printed on each page perfectly. But when I try to print over 3 tables, each table moves upwards and the tables are printed partially on each page (1 ½ user details in each page). ...

Border-Spacing problem in IE7

I've a table on where I need a spacing between two rows of table. I did it in following way. table.fltrTbl { margin:0px; padding:0px; border-collapse:separate; border-spacing:0 11px; } table.fltrTbl td { vertical-align:middle; padding-right:14px; padding-left:0; padding-top:0; padding-bottom:0; ...

Removing spacing between table cells for a single row only

I'd like to know if it's possible to remove the space between table cells on a web page for only one row. I've seen lots of examples showing how to do this for the entire table, but I have a table whose header would look much nicer with no spacing between its cells. Here's an example of what I mean: <table> <tr> <!-- I'd like thes...

Vertically align a div within a table <th>

I have a table header, <th>, that contains a <div> with text. I want to vertically align the div such that it is aligned to the bottom of the header. I am having serious trouble doing this even though it seems like it should be easy. Any help would be great. Thanks i.e. <table> <tr> <th> <div>T<br>E<br>X<br>T</div> <...