So is it any better to use "bigint" rather than "integer" for a data whose value might be a long integer?
Are the actual definitions of smallint, integer, bigint, etc. fixed (no indication of this in the CF5 help) or are they dependant upon the DBMS driver? What about for ODBC datasources - does CF differentiate between the different drivers, or does it treat all of them the same? ----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Monday, February 14, 2005 5:44 PM Subject: Re: CFQUERYPARAM data checking > Jim McAtee wrote: >> When a <cfqueryparam> tag is executed, does CF do any type of bounds >> checking on numeric values? (CF 5) > > It tries to cast it to a certain type in the driver and throws an > error if that fails. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194639 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54