Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Primary Key Number Size (over limit?)

Primary Key Number Size (over limit?)

Thread began 7/16/2009 3:44 pm by webmaster286369 | Last modified 7/18/2009 12:55 pm by webmaster286369 | 3583 views | 4 replies

7/16/2009 3:44 pmwebmaster286369

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?

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.