Primary Key Number Size (over limit?)
I'm using a government issued number as my primary key, but they are large numbers greater than 4,000,000,000.
It is set as BIGINT(11) unsigned in the Mysql DB, but DataAssist Detail page that the wizard creates won't recognize any numbers that are higher then the signed INT limit (2147483647).
What happens is, the Results page of the data is fine, but when trying to view the Detail record, it says "No Record Found".
I can't figure out where there problem is ie where this data limit is being enfored. I'm using Dreamweaver CS3, DataAssist 1.3.1, Firefox 3.0.11 and MySQL 4.1.22.
I really need to use this specific numbering scheme instead of creating a new id as it is referenced by 3 other tables and updating them will be a hassle. There are only about 10,000 records in total. Any help?