table

More Primary / Auto-adding unique IDs per one table in MySQL?

Hi, Is it possible to have two and more primary/automatic-adding unique IDs per one table in MySQL? For example: Primary Key (INT,11);shop_id;invoice_id 1;200;2001 1;201;2011 2;200;2002 2;201;2012 Is it possible to set this to MySQL table ? -> So there are more primary keys for some other value in the table.. ? I am looking for mor...

Select from multiple tables where one has distinct values

I have a simple problem here using SQL views. I just can't seem to figure it out at the moment. I have 2 tables, TableA and TableB. I want to retrieve FieldA in TableA and FieldB in TableB. The two tables are linked using an INNER JOIN. I only want rows where TableA.FieldA are distinct. The returned values should be of the top 10 items...

Retriving live data to a DataGrid

I have a table where constantly records are inserted in, so I like to monitor this records in a DataGrid showing e.g. the 1000 last records inserted; but also, I want to show it like if this grid is a live view of what's happening on the table, some sort of tailing a file. I've thought many ways to do it, for example, I could every five...

dynamic combo-box list in java swt table

I create a Combo-box control in org.eclipse.swt.widgets.Table The code snippet is below ... TableEditor editor = new TableEditor (table_LLSimDataFileInfo); CCombo combo = new CCombo (table_LLSimDataFileInfo, SWT.NONE); combo.setText("CCombo"); combo.add("item 1"); combo.add("item 2"); editor.grabHorizontal = true; ...

TV guide listing semantics. Isn't it a table?

I need to build a web based TV guide listing. When I started I thought all I need is to build a table since it is a tabular data. date 00:00 00:30 01:00 etc... channel 1 show 1 show 2 show 3 etc... channel 2 show 3 show 4 show 5 etc... but alas this is not the situation. While the <th> are for every 30 min. the sh...

Possible to dynamically add an asp:CheckBox control to a TableCell?

Hi everyone, In my .NET application I need to add a checkbox to each row in a dynamically created asp:Table. Is it possible to do that by dynamically creating an asp:CheckBox for each row and somehow put it inside a TableCell object? (In that case how?) Or do I need to replace the asp:table control with something else, like a Repeater ...

User interface for sorting a table by multiple columns

I need a user interface that allows users to sort a table according to multiple columns (e.g. sort by color and then price within color, or alternatively price and then color within price). The only such interface I'm familiar with is the dialogue box found in Excel under data > sort, but this is rather clunky and does not yield itself t...

Finding a row in a data table and deleting it in .Net (style question).

I have a strongly-typed datatable and I search for a row by primary key (FyndBy) and them if the row exists I want to delete it. From a style perspective which of the methods below do you prefer? MyDataRowType selectedRow = table.FindByTablePrimaryKey(something); if (selectedRow != null) selectedRow.Delete(); or if (table.FindByT...

oracle tables in one view

hi, i have 2 tables in an oracle database, which has the same column-names and types. for example: Table1: id, name, comment Table2: id, name, comment How can i show all data from both table in one view? ...

How to get the text content on the swt table with arbitrary controls

I have different controls placed on a table using TableEditor. ... TableItem [] items = table.getItems (); for (int i=0; i<items.length; i++) { TableEditor editor = new TableEditor (table); final Text text1 = new Text (table, SWT.NONE); text1.setText(listSimOnlyComponents.get(i).getName()); text1.setEditable(false); editor.grabHor...

How do I specify unique constraint for multiple columns in MySQL?

I have a table: table votes ( id, user, email, address, primary key(id), ); Now I want to make the columns user, email, address unique (together). How do I do this in MySql? Thanks in advance. Of course the example is just... an example. So please don't worry about the semantics. ...

How would YOU do this: Tables or CSS?

Part I This layout can be done quite simply with 2 HTML tables, one nested inside the other, or even with a single table. It can also be done with CSS, though it might involve a little more thinking. This may not be a real world layout, but I have seen pages that are similar. Consider this a riddle; an exercise to buff up your CSS...

splitting html table in asp.net

I have a html file which has a huge table with 4 columns and multiple rows. I want to display it in an asp 2.0/3.5 page, such that it's first 2 columns appear in one area and other two appear in another area adjacent to it. Some thing like splitting the table in two and displaying. Is there any way i can achieve it? ...

What happens to an existing DB2 view, if the table is dropped ?

If we have created a view on an existing DB2 table and then drop the table. What will happen to the view ? ...

What's the correct way for a cross-browser HTML layout?

I just read codes of a web product that is supposed to support multiple modern browser(including FireFox 3.X, Safari 3.X and IE7+, but not including IE6-). The HTML code uses div instead of table to create table-like effects. Actually, the div's are organized like this: <div> <div> <div style="float:left" id="h...

Deleting a LOT of data in Oracle

I am not a database person, exactly, and most of my db work has been with MySQL, so forgive me if something in this question is incredibly naive. I need to delete 5.5 million rows from an Oracle table that has about 100 million rows. I have all the IDs of the rows I need to delete in a temporary table. If it were a just a few thousand r...

Looking For A .Net Table Component

I'm looking for a table control (aka ListView or DataGridView) that: Can display a series of rows as a "child" of a row - if anyone's spent any time with Access, it does this when it works out associations between rows will let me insert headers into the middle of the table, so I can e.g. group by a particular row and have a header abo...

XHTML/CSS/Javascript way to make a TABLE COLUMN selectable?

I am using a simple TABLE to display tabular data where the rows need to line up but when it comes to selecting the table contents, I only want users to be able to select within each column. Default browser behaviour is to select as rows across all columns but we NEED somehow allow selection only within columns. I was hoping there was a...

Selectable Table Row Jquery Asp.net

Hi all, I would like to create a table where the rows are selectable via jquery. I'd also like to pass certain table cell values from a double click event on a row to another page. Does any one have examples of how this would work? Thanks in advance ...

Making Variable Sized form tables in ASP.Net (there has to be a better way...)

currently I'm writing code to make variable sized tables with asp:controls in them that look something like this: TableRow tableHeader = new TableRow(); tableHeader.ID = "tableHeader"; userTable.Rows.Add(tableHeader); TableCell tableHeaderCell_1 = new TableCell(); tableHeader.Cells.Add(tableHeaderCell_1); TableCell tableHeader...