Primary Key Number Size (over limit?)

[webmaster286369]

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?

[Ray Borduin]

What server language are you using?

[webmaster286369]

i am using php

[Ray Borduin]

The problem is probably in the Recordset on the Details page.

Open the recordset and look in the Advanced tab at the parameters set.

DW allows you to set a parameter to either: "integer", "text", "date", or "floating point"

maybe floating point would work, otherwise it may be a limitation in the DW Recordset that you would have to hand code to get around.

[webmaster286369]

That was the answer Ray, thanx.
Note: the specific options available were "numeric", "text", "date" and "double"
I used 'double' and now it works great!