table

LaTeX: centering a table wider than the text column

I'm including a table in my LaTeX document and the centering works fine if the table isn't wider than the text column above it, but when the table is wider, the left side of the table sticks to the left side of the text column, and the additional width of the table is on the right side of the page, how can I center the table? ...

Need generic div css that does not overlap (like a table)

I'm trying to use divs instead of tables to style boxes around my content. The content can be any size and needs to allow the browser to be resized to any degree. Need the background color and border to contain the content. This works fine with tables. How do I get a div to work the same way? Note: I added "_"s because my non-breakn...

Which table structure is better

We have to create few tables for the sole purpose of reporting in Oracle. Option 1 Receivable Table RefNo Date TrnType eg:Tax, Fee, Premium Amount Option 2 Receivable Table RefNo Date Tax Fee Premium Note: For a given RefNo all types Tax, Fee and Premium or a sub set of them can exist. What would be the optimal structure(Tabl...

How do you set the heights of cells in a table that expands to fill the window in IE?

I am trying to construct a simple, one-column layout. I want the top two rows to have smaller, fixed heights. The third row should expand to fill the rest of the page. Here is my current source: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"&gt; <html> <head> <style type="te...

Enumerating tables used in mysql query?

Is there any way to enumerate tables used in mysql query? Lets say I have query : SELECT * FROM db_people.people_facts pf INNER JOIN db_system.connections sm ON sm.source_id = pf.object_id INNER JOIN db_people.people p ON sm.target_id = p.object_id ORDER BY pf.object_id DESC And i want in return array: $tables = array( [0] => 'db...

How do I freeze the first and last columns of an html table in a scrollable div?

I have a table which has a header row, but also a header column and a total column with several columns in between. Something like this: Name Score 1 Score 2 ... Total -------------------------------------- John 5 6 86 Will 3 7 82 Nick 7 1 74 The en...

How can I make my Windows Form to do and display my database query?

I have 3 Tables: Titles: TitleId (int 6, primary key) TitleName (varchar 50) Authors: AuthorId (int 6, primary key) AuthorName (varchar 50) AuthorsTitles (this is a junction table for Titles and Authors) TitleId (int 6) AuthorId (int 6) There's a "many to many" relation: A Title may have many Authors, and an Author may ha...

Jquery: How can I select all TD elements that don't contain an A element?

I'm trying to use JQuery to select all of the TD's in a table that DON'T have an A tag inside them. (They should just have text). How can I do this? ...

how to insert a a set of table rows after a row in pure JS

I have the following problem: I need to insert N rows after row X. The set of rows i need to insert is passed to my function as chunk of HTML consisting of TR elements. I also have access to the TR after which i need to insert. This is slightly different then what i have done before where i was replacing TBODY with another TBODY. The...

Striped table rows in ASP.NET MVC (without using jQuery or equivalent)

When using an ASP.NET WebForms ListView control to display data in an HTML table I use the following technique in to "stripe" the table rows: <ItemTemplate> <tr class="<%# Container.DisplayIndex % 2 == 0 ? "" : "alternate" %>"> <!-- table cells in here --> </tr> </ItemTemplate> With the following CSS: tr.alternate { ...

Zend_Db_Table: What happens when insert results in an error?

This is probably an easy question to answer, but I don't see it mentioned in the documentation... What happens when insert results in an error? Is an exception thrown? What type? I'm trying to understand what would happen when trying to insert duplicate data in a column that is unique. So I feel like I need to do some checking first......

Concerns - Table layout, iFrames, code deprecation

I am working with a simple table-based layout that uses iFrames as depicted in the example below. This code is rendering well in all modern browsers. The iFrames are usually filled with long tables of data, but there is no odd behavior or clipping. My concern is that it LOOKS like a really bad hack to me. Table-based layout evils a...

Ruby on Rails: How to join two tables

I have an index page that I want to show all the users' profile and their associated photos. I'm using the plugin Paperclip for the photos. In the Profiles controller, I have the instance variable @profile but it shows me the table in the profiles table only and not the photos table. @profile = Profile.find(:all, :include => :photos, ...

Add a new table column to specific ordinal position

Is it possible to add a column to a table at a specific ordinal position in SQL Server? For instance, our tables always have CreatedOn, CreatedBy, LastModifiedOn, LastModifiedBy columns at the "end" of each table definition? I'd like the new column to show up in SSMS above these columns. If I am scripting all my database changes, is t...

SQL Server 2000 temp table vs table variable

What would be more efficient in storing some temp data (50k rows in one and 50k in another) to perform come calculation. I'll be doing this process once, nightly. How do you check the efficiency when comparing something like this? ...

Long Line in HTML Table tanting the layout of other lines

I have a html table serving as layout for a page (Bad practice I know). This table goes something like this: Label1 Value1 Label2 Value2 Label3 Value3 Label4 Value4a Value4b Value4c Value4d I just added a validation error message that can be quite big to line one, so now it is: Label1 Value1 ErrorMessage Labe...

[Beginner] JQuery reusable functions

Completely new to JQuery so I am learning everyday. One thing I noticed is how easy it is, you can just write $('div#test).remove(); But I am looking for an example on how to reuse some code, eg.: function RemoveTableRow(row, id) { $(row).remove(); // id should be used for ajax call } And then add a 'onclick' on my anchor-...

asp:to add web control in table cell of table control (web control ).

i have inserted a table web control in a panel.in that table 's cells i want to insert other user control like label, panel .i am not able to do that.is there any difference in normal table for layout and table web control.if it is.then how can i insert simple table in a panel. ...

Wrapping tabular data in HTML

I have some data with one row of headers and one or more rows of values that I want to display. Currently, I'm using an HTML table, but I've come across situations where I have so many columns, the table goes off the end of the screen. Or that some column names are so long (they're usually just a single word that have underscores as spac...

Indented hierarchical table structure

I am trying to create a hierarchical display of nested tables, where each sub level is indented further from the parent. I'm open to using table or div. The closest I've come is below. It looks mostly correct in IE (except that the borders on the right are mashed together). In Chrome the sub item border is extending beyond the parent on ...