On my webpage I want to able to present tabular data and give the user the possibility to copy it directly into excel. This however doesn't work, all of the data is pasted in one cell: <table> <tr><td>Column 1</td><td>Column 2</td></tr> <tr><td>Data 1.1</td><td>Data 2.1</td></tr> <tr><td>Data 1.2</td><td>Data 2.2</td></tr> </table> Ho...
I'm trying to implement html table row selection in IE7 and FF3. When user clicks on the row with ctrl key, he can select separate rows. When he clicks with shift key he can select rows range (so in other words: I'm trying to implement items selection like in the select box or in file explorer). I have javascript for highlighting selec...
Problem: I have HTML markup to deal with that consists of multiple tables nested inside another table. I would like the "inner tables" to all be the same width. I would also like all of the "inner tables" to be no wider than the width of the widest "inner table" in its natural state. I do not want to simply set the width of all the tabl...
<table border="1" width="100%" ID="Table2"> <tr> <td>100</td> </tr> </table> This code still leaves and "inch" of space on both sides of the table. Trying to get the table to span the entire width of the page. Thanks. ...
I am a new php and mysql programmer. I am handling quite large amount of data, and in future it will grow slowly, thus I am using hash table. I have couple of questions: Does mysql have hash table built in function? If yes, how to use that? After couple of days doing research about hash table. I briefly know what hash table is but I ju...
Let's say, I have : Key | Indexes | Key-values ----+---------+------------ 001 | 100001 | Alex 002 | 100002 | Micheal 003 | 100003 | Daniel Lets say, we want to search 001, how to do the fast searching process using hash table? Isn't it the same as we use the "SELECT * from .. " in mysql? I read alot, they say, the "SELECT *" sea...
I have table with multiple rows, showing items for sale. When the user clicks on a row, a Javascript inserts / shows a new row right beneath it with details about the item. The issue is when the description is long, it forces the column widths to readjust / resize. This shifts the columns positions and is really annoying, especially for ...
Say I have a VIEW on my database, and I want to send a file to someone to create that views output as a real TABLE on their database. mysqldump of course only exports the 'create view...' statement (well ok it includes the create table, but no data) What I have done is simply duplicate the view as a real table and dump that. But for a...
Hi, I have a table whose columns indicate a property of data items. Each item is then placed into its appropriate column, meaning some columns might be empty, and certainly the columns do not all contain the same number of elements (or rather, the last n elements in each column are empty, apart from the column that has the most elements...
I want to backup a table saving the copy in the same database with another name. I want to do it programatically using .NET 2.0 (preferably C#). Someone can point me what should I do? ...
I have been working on an application in Django. To begin with, for simplicity, I had been using sqlite3 for the database. However, once I moved to PostgreSQL, I've run into a bit of a problem: the primary key does not reset once I clear out a table. This app is a game that is played over a long time period (weeks). As such, every t...
I am using SQL Server for the first time and I see that a column property is called Is Identity. What doeds this mean? What are the advantages of marking a column property as Is Identity = Yes ? Thanks in advance. ...
I have 2 tables to search. Searching photos for keywords, title and description. The keywords have been split off into a separate table. My advanced search will allow searching on all 3 but the basic will just be the keyword table. Basic table setup: PHOTO Table PhotoID Name Title Description WORD2PHOTO Table WordID PhotoID Word ...
The table in question is part of a database that a vendor's software uses on our network. The table contains metadata about files. The schema of the table is as follows Metadata ResultID (PK, int, not null) MappedFieldname (char(50), not null) Fieldname (PK, char(50), not null) Fieldvalue (text, null) There is a clustered index ...
Hi guys, I know PRIMARY key is to have unique value, what about INDEX? What is the function of a table column with INDEX? ...
I am stuck in a weird Design problem, I am working on a two type of profiles Models, User profile (belongs to User) others that are maintain in-site as "bots" (doesn't belong to anybody) The typical OO behaviour of these two types of Profiles is same but only the important attributes/properties are common ( the very important on...
Does anyone know of a class in Java that has a list of elements, so that the elements are sortable by any of the elements members? The idea is basically to have some database table-like implementation, where you can just add fields to sort by. To illustrate: SomeTable table = new SomeTable(); table.addField("name", String); table.addFie...
Hi, I'm having problems with JTables. I'm adding two tables to a panel, the tables are within a scrollpane, but when the app shows up, the tables always occupy more space than the number of rows, wasting my available space. I'm using groovy and swingbuilder to create the tables, here's the code: scrollPane(){ panel(layout: new Mig...
What is the best way to make a tables row a link? I currently am using jquery to zebra stripe the rows and also to highlight the onmouseover/off selected row so if js is the answer please use jquery. ...
I have an Employee class with a Name property of class Name and a Contact property of type Contact. The Name class has two string properties: FirstName and LastName and the Contact class has properties like PhoneNumber and EmailAddress. All of the data is found in one table and assume that it cannot be changed. What would my maps look...