table

How can I set a <td> width to visually truncate its displayed contents?

I'm trying to set a column width of a table, which works fine until it gets to the point where child elements would be visually truncated ... then it won't size any smaller. ("visually truncated"-what doesn't fit appears to be hidden behind the next column) Here is some sample code to demonstrate my problem: <!DOCTYPE html PUBLIC "-//...

generate DDL for sybase tables and indexes

I'm looking for a command line tool to generate DDL for both tables and indexes (nothing more complicated is needed) for some sybase tables in databases I take care of. I have access to gui tools for viewing at individual DDLs, and I could cut and paste them, but I want something that will go through all the tables in a datbase and gene...

Frozen table header inside scrollable div

I've three divs. Header, central and footer. There is a table in central div (gridview) which is almost always longer than outer div. So I've made this div scrollable vertically. The question is: how can I make table header that it would be visible after div is scrolled down? I could have done this header with separate div or table and m...

Is there an easy way to make a pleasing mediawiki table?

I use a MediaWiki instance on a thumb drive to keep track of a ton of stuff. In the past, I've been in a hurry so I haven't had the chance to look for a nice way to make tables, so this syntax has served my purposes well: {| border=1 ... |} Now I want something a little nicer; I'm used to using CSS to make nicer table borders, but I'...

Emulating Excel's "freeze cells" in an HTML table

I have an HTML table that contains a large number of rows and columns. The top row contains headers, and the first cell in every row below that contains a header. I need to allow the user to scroll the table whilst keeping the top row and left column visible at all times (similar to what can be achieved using the "freeze cells" option i...

Inserting Dates into HTML Table Cells

I am wanting to have a series of dates (mainly Month, Day, Year) displayed within a vertical arrangement of table cells on a web page. The first date needs to be the current date minus one day, with the next date in the sequence be the current date, The remaining dates need to incrementally be one day in future out to 16 days. Can som...

Need help with SQL 2005 SELECT CASE <column> statement

Hi everyone, I would really appreciate help with this, I am seriously stuck. Basically I have a table that looks like this: SSS_DOWID Name Mon Tue Wed Thu Fri Sat Sun Description 2 M Y N N N N N N Monday 3 MF Y N N N Y N N Monday, Friday ....... 18 ...

How to make php open a html-file, go two lines up, then write there and close?

I am making a litte php-file to log some ip addresses. It is going to write the ips and date/time into a html-file. The html-file is going to be a table. So I want to mak it like this: <table cellpadding="6" rules="groups" frame="no"> <thead> <tr><th>IP</th><th>Date</th><th>Time</th></tr> </thead> <tbody> <tr><td>192.168.0.1</td><td>3...

Two Tables Same Height

I have a problem. I want two tables to have the same height. If the left table contain longer text than the right table i want it to be as long as the left table. This is how it looks now: http://i42.tinypic.com/34rwys1.png I cant set height because that would limit how much text you can write.. This is how i want it: http://i43.tinyp...

How to vertically align Paragraphs within a Table using Reportlab?

I'm using Reportlab to generate report cards. The report cards are basically one big Table object. Some of the content in the table cells needs to wrap, specifically titles and comments, and I also need to bold certain elements. To accomplish both the wrapping and ability to bold, I'm using Paragraph objects within the Table. My tabl...

Table showed different in IE from Opera

Hi, I have a table with a code like this: <table cellpadding="6" rules="groups" frame="no"> <thead> <tr><th>Date</th><th>Length</th><th>Time</th></tr> </thead> <tbody> <tr><td>31. January1</td><td>28 km</td><td>3 hours</tr> </tbody></table> The problem is that in IE the table has frame and a tableborder = 1. What to do? Thanks ...

Column-Size on GTK TreeViews

How can I set the horizontal size of a specific column on a GTK-TreeView? I have 4 columns on my TreeView and the last one expands on the rest of the free space. How can I set the first or second column to be expanded on the free space os set a fixed width on all columns? ...

How to quickly initialise an associative table in Lua ?

In Lua, you can create a table the following way : local t = { 1, 2, 3, 4, 5 } However, I want to create an associative table, I have to do it the following way : local t = {} t['foo'] = 1 t['bar'] = 2 The following gives an error : local t = { 'foo' = 1, 'bar' = 2 } Is there a way to do it similarly to my first code snippet ? ...

SQL Server: Is it faster to retrieve or filter data from views using stored procedure than getting or filtering data from tables using stored procedure?

Hi, are there performance issues when retrieving and filtering data from views than from tables by using a stored procedure? Simplification: Is it faster to retrieve or filter data from views using stored procedure than getting or filtering data from tables using stored procedure? ...

Microsoft reporting services trouble with subreport flow

Hi I have a subreport in a reporting services main report. The subreport starts approximately on the middle of the page in the main report. If i have few detail lines in the subreport so that all can be rendered on page one, everything is ok. However, if I have more detail lines in the subreport so that it's not possible to print all...

Design 1-to-1 relationship DB tables?

A DB design question: when do you decide to use 1 to 1 relation tables? One of the places I see this is, for example, when you have a User and UserProfile table, people split them instead of putting all columns just in a User table. Technically, you can just put all the columns in one table since their relationship is 1-to-1. I know...

getting innerHTML from asp:Table control

I would like to capture the "innerHTML of a asp:Table control from a button click. i.e. webforms page has an asp:Table control that is dynamically populated at run time. I need a quick/dirty print button to print the contents of the table. Ideally, I'd like to just have a simple way to grab the markup of the rendered table to squirt to a...

MySQL Simple Table Synchronization?

Ok, So I'm developing a website which to begin with will have 3 clear sub sites: Forum, News and a Calendar. Each sub site will have it's own database and common to all of these databases will be a user table which needs to be in each database so that joins can be done. How can I synchronize all the user tables so that it doesn't matte...

Is there efficient SQL to query a portion of a large table

The typical way of selecting data is: select * from my_table But what if the table contains 10 million records and you only want records 300,010 to 300,020 Is there a way to create a SQL statement on Microsoft SQL that only gets 10 records at once? Eg select * from my_table from records 300,010 to 300,020 This would be way more ef...

Easiest way to center tables and other elements?

Okay so what is the best way to make things center properly? Once i start messing around with tables, things ether start shifting left or right, destroying the balance. How can i make it so everything is always centered? Right now this will lead to the table being messed up, and have the right edge go off the screen. What can i do? Her...