table

text in tables?

Hello, I like to organize a lot of information from literature reviews in "tables" (information not unlike product comparisons, but for scientific research), but often the information I enter can contain lines or paragraphs of text and becomes unwieldy in a spreadsheet. I've heard SQL relational tables are often used for this purpose; fo...

Tablesorter 2.0.3 colspan issue

Hi, I a couple of issues using Tablesorter 2.0.3. The first issue is when I set a colspan on my table. Basically when I do this as below it doesn't sort the respective columns. <table> <thead> <th colspan="3"></th> <th>Four</th> <th>Five</th> <th>Six</th> <th>Seven</th> </thead> <tbody...

Style row or column rather than cells when border-collapse: separate

I have a table which for other reasons I prefer to keep table-collapse: separate. However, I would like to be able to highlight an individual row or column. Unfortunately, it seems that any style applied to the <tr> or <col> tags only applies to the cells, not the space between them. For instance: <style> td { width: 10px; height: ...

Limit a sqlite Table's Maximum Number of Rows

I am looking to implement a sort of 'activity log' table where actions a user does are stored in a sqlite table and then presented to the user so that they can see the latest activity they have done. However, naturally, I don't feel it is necessary to keep every single bit of history, so I am wondering if there is a way to configure the ...

MySQL Row-level Revision Control

I’m creating revision control for data in our database. It will have the ability to store revisions, rollback, and rollback rollbacks. The database tables I’m using that needs to be revisioned is below: objects object_chunks object_attributes Objects is the main object, chunks are grouped up sections of the object, and attributes are a...

Associatively sorting a table by value in Lua

I have a key => value table I'd like to sort in Lua. The keys are all integers, but aren't consecutive (and have meaning). Lua's only sort function appears to be table.sort, which treats tables as simple arrays, discarding the original keys and their association with particular items. Instead, I'd essentially like to be able to use PH...

Removing unwanted table cell borders with css

Hello everyone, I have a peculiar and frustrating problem. For the simple markup: <table> <thead> <tr><th>1</th><th>2</th><th>3</th></tr> </thead> <tbody> <tr><td>a</td><td>b></td><td>c</td></tr> <tr class='odd'><td>x</td><td>y</td><td>z</td></tr> </tbody> </table> I apply different background-...

Select a complete table with javascript (to be copied to clipboard)

Hello everyone, I was wondering if anybody knows how to select using js the complete table, so that the user can right-click on the selection, copy it to the clipboard and then paste it on excel. If you select the table manually, the process works perfectly. But sometimes, if the table height is a few times larger than the screen, sele...

Maximum number of columns in a table

Problem1: What is the maximum no of columns we can have in a table Problem2: What is the maximum no of columns we should have in a table ...

CakePHP HABTM Plugin table naming conventions (for 1.3)

Hi everyone, I know naming conventions for tables used by plugins generally start with the name of the plugin and then the model pluralized. For example lets say I had a plugin called Poll, with a model also called PollPoll and another model called PollTag then the resulting table names would be poll_polls and poll_tags. They would also ...

activate C# function from html table

Hi! How can i activate a C# function from a simple html table? i'm working with ASP .Net Appreciate, ...

MySQL - Multiple tables vs. single table

I have been working on saving/loading, and i came across that i have to load/save alot of tables, cause i split my tables into categories eg. characters, character_appearance, character_preferences, character_session, etc (i use the LEFT JOIN clause to load) Would it be better if i just put all the columns into a single table instead of...

add dynamic html table to ASP form

Hi! i created a dynamic table with HtmlTable, HtmlTableRow and HtmlTableCell. finally i've added it to the form with Form.Controls.Add(thisHtmlTable); but the table was added in the wrong place... `<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">` `<form id="formPort">` <!--this is the plac...

table-header-group and table-footer-group in a Div

Is there a way of using table-header-group and table-footer-group in a div instead of in a thead or tfoot? ...

CSS Table cell border overlapping table border

I'm hardly an expert in css, so this is a bit frustrating. I have a grid that was filled with a repeater. I want each row to have a 1px border along the bottom to visually separate the rows. I also want a dark gray border on each side of the table. With the following CSS for this table: #repeaterTable { borde...

HtmlTable, HtmlTableRow, HtmlTableCell - creating thead, tbody and tfoot

Hi! I'm working with c# ASP .Net, HtmlTable, HtmlTableRow, HtmlTableCell to create a table. for example... i need to have some cells to be wrapped by <tfoot> and </tfoot> i tried to do it with HtmlGenericControl to wrap these cells with the tag "tfoot" to the HtmlTable but it didn't work. i know that HtmlTableCell can have in the con...

How to implement a modifiable table on a web page?

I would like to create an HTML page that contains a table, where one column is editable by any user (after logging in). (As a bonus, the table should be sortable on any column.) It's sort of like a wiki page, except the users are not supposed to edit wiki source code, but simply modify values in the modifiable column of the table. Are ...

MS Access 2003 - Auto assigning an Identification Number

So I have a little db that is used for new hires in terms of who, where and what they are issued. One thing that is issued is laptops with little barcode/ID numbers, and I would like the db to auto assign an available ID number when the user is saved to the db. So I have a form that users use to input the information, and it is unbound,...

Slow Update When Using Oracle PL/SQL Table

We're using a PL/SQL table (named pTable) to collect a number of ids to be updated. However, the statement UPDATE aTable SET aColumn = 1 WHERE id IN (SELECT COLUMN_VALUE FROM TABLE (pTable)); takes a long time to execute. It seems that the optimizer comes up with a very bad execution plan, instead of using the...

PHP Doctrine 1.2 table names

I'm trying to upgrade my doctrine ORM from 1.1.6 to 1.2.1 but i've enountered a BC issue with table names. Some of my table names have several words (e.g. t_foo_bar for class FooBar) where the t_ prefix is generated automatically with: $manager->setAttribute(Doctrine_Core::ATTR_TBLNAME_FORMAT, 't_%s'); This worked well in previous ve...