The problem almost certainly lies in the field definitions in the data base tables. I suspect the "double" values, but I think you should take a look at the int values as well. They look huge. I can't speak to mySQL exactly as I use other DBs, but most DBs compact integer data into binary, so field sizes are not number of characters. For example, in SQL Server (smallint 4) can store any number from from -2^15 through 2^15 - 1 (2 to the power of... binary).
Here's a link that may help with MYSQL data types: http://www.htmlite.com/mysql003.php Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287476 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4