I'm trying to confirm or deny whether you can define a table column in MS Access 2003 as a set. It seems this is implemented in Office 2007 - you can define a column to have a 'multi-select list' in the query/lookup, but this feature appears to be unique to the new access 2007 file format as far as I can determine. Worded another way, ...
I have an issue with a table containing three cells in one row. Two of these (left and right) have fixed width/height and should display an image (or shrink to 0 when no image is present). The middle cell takes the remaining space withing the fixed total with of the table. The problem: now I end up with 3px of extra space by which the '...
Hi, I want to check if a table with a specific name exists in a database i've connected to using php and pdo. It has to work on all database backends ... MySQL, SQLite, ... best regards, andre ...
I have a list of half a dozen MSSQL 2008 tables that I would like to remove at once from my database. The data has been entirely migrated to new tables. There is no reference in the new tables to the old tables. The problem being that old tables comes with loads of inner FK constraints that have been autogenerated by a tool (aspnet_regs...
In my application, I am storing a small table containing 50 records in a singleton class because the data in this table hardly changes - e.g. the list of countries. Although, the concept is not good, I have to continue with it right now. Is there any solution in Hibernate which observe change in the table and on change, invoke a method...
I have an example of a simple HTML table that contains a number of div blocks. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <head></head> <body> <table border=1 width="1000px" > <tr><td></td><td></td><td></td><td></td></tr> <tr valign="top"><td col...
I have a table on a SQL Server 2000 database, which I want copied verbatim to a 2008 server. I tried to do it manually with INSERT/UPDATE triggers, but this technique runs in a distributed transaction, which does not work because I apparently have to enable MSDTC and the firewall; I don't want to do any of that. Are there any other way...
I'm using Reporting Services 2008 and Report Builder 2.0. I've used a tablix to display my data in a simple way - essentially each row in the database receives a row in the tablix - nothing fancy. I have a header row with a name for each column. I also have a super-header which groups together a few of the columns into logical groups (e....
I'm having problems using a table inside a ContentPane. It seems to work fine in Firefox but is invisible in Internet Explorer 7. The html below demonstrates what I mean. In Firefox you get: Before Table This is the table After Table In Internet Explorer 7 you get: Before Table After Table No table at all. Does anyone know the cause ...
How would you go about displaying huge amount of rows in SWT table? Huge is something above 20K rows, 20 columns. Don't ask me why I need to show that much data, it's not the point. The point is how to make it work as fast as possible so that end user won't get bored waiting. Each row displays an instance of some object, columns are its ...
Is there anyway I can erase all the duplicate entries from a certain table (users)? Here is a sample of the type of entries I have. I must say the table users consists of 3 fields, ID, user, and pass. mysql_query("DELETE FROM users WHERE ???") or die(mysql_error()); randomtest randomtest randomtest nextfile baby randomtest dog anothert...
Hi! I'm trying to run multiple queries on multiple tables- similar to "select count(*) from TableA where x=1" per table. What I'd like to do, is get all of the count(*) values that are returned and sum them into a single value... Any ideas? ...
I've got an inventory table that needs to have certain in each row, and then in the last column in each row, i want to loop out each item that was used per a specific inventory update i.e. one row would have one column for the customername, one column for the date of the inventory transaction, one for the type of transaction, the specif...
Hi guys! I have this problem on my website's layout, and it's basically preventing me from continue it, it's destroying everything. here goes the HTLM code: <table cellpadding="0" cellspacing="0" width="446" height="362"> <!-- MSTableType="layout" --> <tr> <td valign="top" colspan="2" height="110"> <p align="cente...
I want to create a database with 3 tables. One for posts and one for tags and one that links posts to tags with the post_id and tag_id functioning as foreign key references. Can you explain what an Index would be in this scenario and how it differs from a Foreign Key and how that impacts my database design? ...
$query = "SELECT posts.* FROM map, posts, tags WHERE map.tag_id = tags.id AND (tags.name IN ('mysql', 'database')) AND map.post_id = posts.id GROUP BY posts.id HAVING COUNT( posts.id ) = 2"; I don't understand the last row. Can someone please explain it for me? What is the difference if I don't have it there? ...
i dont understand one thing. why do i have to use foreign key to link to a primary key in another table? when i query i type like "where table1.foreignkeycolumn = table2.primarykeycolumn. does this not work if i havent assigned a foreign key to primarykey? ...
When I'm trying to create a foreign key linked to a primary key in another table I get: #1452 - Cannot add or update a child row: a foreign key constraint fails (`fayer`.`#sql-225c_1d3`, CONSTRAINT `#sql-225c_1d3_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE) I have checked that all tables are usin...
using jquery , how can i create a clone of a Row which has display: none as its style , and append to the end of the tbody ? My table is <table> <tbody> <tr id="tRow0" style="display : none ;"> <td> // Some contents (textbox,dropdown etc..) </td> </tr> </tbody> </table> I want to create a clone of the hidden row...
So, I'm building a table data editor, and need funcitonality that's not available in the ready-built plugins. This is my code so far: http://sandman.net/test/tables.php But I'm having problem with my "add column" ("Lägg till kolumn") button, which correctly adds a column, but makes the table one column larger in the process. I've even ...