table

Infopath 2007 Repeating table - two data connections

I have two data connections. One (we'll call DC1) pulls FIRSTNAME and LASTNAME from a database. The other, (we'll call DC2) uses this information to query a web service that returns a USERNAME after matching it to another database. On my form, I have a repeating table that lists all the information from DC1. In the repeating table,...

Table which doesn't shrink while resizing

Hello, Can someone please tell me how to create a table which doesn't shrink when the window is resized. I tried creating a table with a fixed width, but it causes problems in the Print Preview.I also tried white-space:nowrap which also didn't help. Can someone please help me to fix this. ...

iText cell borders cutting through text

I am writing a program that generates a pdf or rtf file with a table in it, using iText. I used the iText class table and cell, rather than the more specific RtfTable or pdfTable so that either file can be generated at the end. I needed to set the cell padding to a value of -1, or else there was too much space between each row of data ...

How to stop text in table HTML

How to stop text from make the table width longer and make a new line insted ...

MySQL enum column from anothertable column

I'm sure this is either totally impossible or really easy: If I'm creating a table and I want one of the columns to have limited options, it seems that I use either the ENUM or SET value type. But I have to define the possible values at that moment. What if I have another table which has two columns, a primary key column and a data colu...

IE bug with TD's tables and whitespace?

Hi there, I have a page that is using tables, in FF etc it works perfect, but in IE7 it causes issues, its basically where the four corners have a td and and img (its a rounded corner form) .. if i remove the whitespace from the document it fixes the issue.. What actually happens is that it messes up the tables.. it puts a thin white li...

Cart table structure and update only particular item in cart.

I am trying to design database for a simple online shopping cart.I am not getting the idea of what to place for the table shopping cart.Is not it ok to create cart id as primary key?And later on while updating the items in a cart,what would be the appropriate logic to update only the changed field(say quantity) of a particular product?Pl...

Firefox crashes rendering large html table (20,000+ rows)

I understand that rendering a table this large is pushing the limits of any browser. However, I was curious as to why a table that is significantly large (20,000+ rows) crashes Firefox, while all other browsers render it relatively quickly. I am using ASP.NET and writing the table html directly to the buffer with Response.Write. I initi...

SQL Union All to display old data with new data?

Ok, In MS Access, I have some reports that use some queries, to show data, within a date range. The queries use aliases, if, sum, and avg functions, and join multiple tables to get its data. I'd like to know if i could use a UNION ALL, with a table that has all the needed fields, to display this new data from this table, along with th...

Is it better to use fixed or percentage column width for an HTML Table?

I'm displaying some tabular data on my website so I decided to use some tables. Is it a best practice to use fixed width for your table columns (ie, 100px) or to use percentage based widths? ...

Handle either a list or single integer as an argument

A function should select rows in a table based on the row name (column 2 in this case). It should be able to take either a single name or a list of names as arguments and handle them correctly. This is what I have now, but ideally there wouldn't be this duplicated code and something like exceptions would be used intelligently to choose ...

How to design a table to store checkboxes in form?

Hi my user says he needs to mark several checkboxes in a form (form1) and then get report based on values stored in those checkboxes.for example, image that there are 5 checkboxes in form.3 of them belong to a category named "Econimics", and remaining 2 checkboxes belong to another category named others. Now, my question is: how shoul...

php list into a table

I asked a question yesterday and the answer I got has answered the first part of my problem - I now have a query that generates a list similar to this: fname, sname, uname, assignment, task, grade joe, blogs, joe.blogs, 1, 1, 52 joe, blogs, joe.blogs, 1, 2, 58 jim, blogs, jim.blogs, 1, 1, 95 jim, blogs, jim.blogs, 1, 2, 86 amy, blogs, a...

Update multiple columns in a TABLE from another TABLE (Oracle)

I would like to update multiple columns in one table based on values in another. I think I know how to write an update statement in T-SQL that does what I want (haven't tested the below). Problem is I'm trying to translate this for an Oracle database. Does anyone know how to do the following in Oracle: UPDATE oldauth SET AUTHUNIQUENA...

How to execute Table SP in csharp

I looked at the SQLTeam website but now am having a new problem cause I have an IDENTITY column and their example does not. I have SQL Server 2008 and VS 2008. I am trying to execute the InsertPIF SP using C# and a table UDT, but am getting an exception. I have looked at a SQLTeam website example with a Table UDT, but their example...

MySQL error 1005 on table create -- wtf

My table definition: CREATE TABLE x ( a INT NOT NULL, FOREIGN KEY (a) REFERENCES a (id) ON UPDATE CASCADE ON DELETE CASCADE ) ENGINE = InnoDB; which produces the following error: ERROR 1005 (HY000): Can't create table './abc/x.frm' (errno: 150) What does this mean? ...

Design ideas for displaying large amounts of data in an html table

I have an html table that literally has like 30 columns of data, and I'm having a hard time framing it in such a way that it can be visible without massive left/right scrolling. One thing I was wondering is if anyone has ever seen anything clever with column headers? Some of them just can't be abbreviated down enough, but the column he...

Lua garbage collection of Tables, nested Tables

[I've read the Lua manual, but it did not provide solid answers.] Let's say I have a Lua Table, acting as an indexed array: local myArray = {}; myArray[1] = "Foo"; myArray[2] = "Bar"; How do I best dispose of this Table? Do I just set myArray to nil? Or do I have to iterate through array and set each indexed element to nil? Simila...

setting rowspan on colgroup?

Simple (I hope), HTML question. Let's say I have a column group that spans 3 columns. But it also spans 9 rows. But in actuality, I want there to be 3 levels of columns (so basically, 3 columns, split across 9 rows). The only objectives really are: a) avoid embedding tables (for various reasons) b) keep the sections modular. c) allow ...

How to read Result of SELECT * from Joined Tables With Duplicate Column Names in .NET

I am a PHP/MYSQL developer, slowly venturing into the realm of C#/MSSQL and I am having a problem in C# when it comes to reading an MSSQL query that joins two tables. Given the two tables: TableA: int:id VARCHAR(50):name int:b_id TableB: int:id VARCHAR(50):name And given the query SELECT * FROM TableA,TableB WHERE TableA.b_id = ...