table

How to get table cells evenly spaced?

I'm trying to create a page with a number of static html tables on them. What do I need to do to get them to display each column the same size as each other column in the table? The HTML is as follows: <span class="Emphasis">Interest rates</span><br /> <table cellpadding="0px" cellspacing="0px" class="PerformanceTable"> <tr><th c...

Converting table based layout into a div/css based one.

I'm supposed to rewrite the UI for a rather large web application. The thing is that the layout is completely based on tables and if I could somehow, semi automatically, convert the tables into divs it would save me a huge amount of time. What are the best practices when doing something like this? Is this a good idea at all? The appli...

How do I merge cells of the same column in LyX?

I have 3 subfigures I want to arrange so that 1 will be in the left and 2 will be in the right (one above the other): Figure 1 | Figure 2 Figure 1 | Figure 3 Figure 1 should appear only once of course - across the entire column. I thought I should use 2x2 table to arrange them, but I can't find a way to merge the two cells ...

XML Table layout? Two EQUAL-width rows filled with equally width buttons??

Hi heres a part from my XML for LAND format: <TableLayout android:layout_height="wrap_content" android:layout_width="wrap_content" android:layout_gravity="center" android:stretchColumns="*"> <TableRow> <Button android:id="@+id/countbutton" android:text="@string/plus1"/> <Button a...

Why should I use display:table instead of table

What's the benefits of structuring my site with divs and apply the display:table property ( display:tr, display:tr). Doesn't this mean that the divs will behave exactly like tr and td elements? I know I probably shouldn’t use tables or table behavior for layout at all but I'm just curious if there's a difference and a benefit? ...

Duplicating table in MYSQL without copying one row at a time

Hi folks, I want to duplicate a very large table, but I do not want to copy it row by row. Is there a way to duplicate it? For example, you can TRUNCATE w/o deleting row/row, so i was wondering if there is something similar for copying entire tables UPDATE: row by row insert is very painful (because of 120M rows). Anyway to avoid that...

How do I render .NET TableCell as TH instead of TD?

I'm dynamically building a .NET Table, including TableRows with TablesSection set, resulting in 1 THEAD row and multiple TBODY rows. Now I need to get the TableCells in the THEAD row to render with TH tags rather than TD tags. How do I do that? I haven't found a TableCell attribute for that, and it won let me add Literals to the row C...

IE7 is making my life miserable! Getting gaps between html table columns (w/ colspan) with css toggle

Copy/paste this html code snippet and try it out in IE7. When you toggle the hidden columns it leaves a gap between the columns. In Firefox it works fine, the columns touch when minimized. Haven't tried IE8 yet, would be curious to hear how it works there. Any ideas? I've tried a bunch of things in the CSS like table-layout:fixed bu...

MySQL - What is wrong with this query or my database? Terrible performance.

SELECT * from `employees` a LEFT JOIN (SELECT phone1 p1, count(*) c, FROM `employees` GROUP BY phone1) b ON a.phone1 = b.p1; I'm not sure if it is this query in particular that has the problem. I have been getting terrible performance in general with this database. The table in question has 120,000 rows. I have tried this particular q...

How can I transform this haml into a table?

I have the following haml code: - @theLinks.each_index do |x| %br %form{:action=>'/Download', :method=>"post",:enctype=>"multipart/form-data"} %input{:type=>"submit", :name=>"#{@theLinks[x].url}", :value=>"Name: #{@theLinks[x].Name} Study Time: #{@theLinks[x].studyTime} Comments: #{@theLinks[x].comments}"} Basically, for ea...

How can I css for List/grid in div with border?

I want to create a list table in DIV with border. When more content of width of a column then line break and border increase but other column border not increase. see the example: Div based CSS Table .list_container{ float:left; width: 550px; margin-bottom:10...

CSS Gridlines For Alternating Columns

I have created a table with 20 rows and 10 columns. I would like to create a gridline separating every two columns. So, between column 2 and 3 there would be a line separating them. There should also be lines separating columns 4 and 5, coulumns 6 and 7, and columns 8 and 9. But I do not want to have a line separating columns 1 and...

Display PHP Query Array in the table

Hi all I would like to display my Query from Mysql on the table. However, my data is like this: Array([0]=>data1, [1]=>data2, [2]=>data3,[3]=>data4,[4]=>pic1,[5]=>pic2,[6]=>pic3,[7]=>pic4); I want to display my table as |data1 | data2 |data3 |data4 |pic1 | pic2 |pic3 |pic4 I know how to display the data in the single ling like...

DELETE from two tables with one OUTPUT clause?

This deletes the document from the Document table and outputs information about the deleted document into the FinishedDocument table. DELETE FROM Document OUTPUT Deleted.DocumentId , Deleted.DocumentDescription INTO FinishedDocument WHERE DocumentId = @DocumentId I need to delete the document not just from the Document table, but ...

General purpose Table structure in Java (like ResultSet)

Does anyone know if there's a good general-purpose Table-based structure that I can use for manipulating data? ResultSet is an interface, so am I stuck having to fully implement something if I want similar functionality without a database? Apache Commons Collections does not seem to have anything immediately suitable. ...

jQuery table filter with text, checkboxes, selects

Need to filter a table from outside of the table, with a text search, checkboxes, and selects. PicNet Table Filter for jQuery works for both searching and using checkboxes outside of the table... though I can't find any examples of how to get a select box to work. Anyone know? *I might be getting too specific here, but thought I'd at le...

PHP SQL, SELECT corresponding data from 3 tables at once?

I have 3 tables, 'u' 'd' 's' 'u' has userid divid 'd' has divid divname 's' has sname primaryuserid secondaryuserid Now what I'd like to do is display a table with rows of the following format userid, divname, sname Plus figure out a way to decipher whether userid is a primary or secondary for this sname table. I'm abl...

What is the most standard and compatible way to make a whole table row into a link?

Obviously you can't just surround the <tr> tag with an <a> tag and call it a day; this is invalid and doesn't even work. I have seen JavaScript used, but then what happens to browsers that don't support JavaScript? What is the best way to make an entire table row <tr> into a link? Edit: At the request of Lerxst, here is an example of a ...

jquery: Enable sorting on a table and keeping it sorted while inserting new rows

I have a table with data and I want the user to be able to sort it in different ways. I have tried the tablesorter plugin for jquery, but there are some issues I can't quite figure out of. What I am struggling with is how to insert new rows while keeping the table sorted according to how the user currently have chosen. The best would be...

SQLite table creation date

Is there a way to query the creation date of a table in SQLite? I am new to SQL, overall. I just found this http://stackoverflow.com/questions/1171019/sql-server-table-creation-date-query. I am assuming that sqlite_master is the equivalent to sys.tables in SQLite. Is that correct? But then my sqlite_master table only has the columns "typ...