When a cfqueryparam tag is executed, does CF do any type of bounds
checking on numeric values? (CF 5)
For instance, if I'm inserting a longint into a table, with the following
code would CF throw an error if the value of the id were greater than some
integer value?
cfqueryparam
I'm pretty sure it just does type checking, not bound checking. The
exception would be the maxlength attribute for string lengths.
cheers,
barneyb
On Mon, 14 Feb 2005 16:57:17 -0700, Jim McAtee [EMAIL PROTECTED] wrote:
When a cfqueryparam tag is executed, does CF do any type of bounds
Then what's the reason behind all the possible values (data types) for the
cfsqltype attribute?
- Original Message -
From: Barney Boisvert [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, February 14, 2005 5:04 PM
Subject: Re: CFQUERYPARAM data checking
I'm
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.
Jochem
~|
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
On Mon, 14 Feb 2005 17:57:14 -0700, Jim McAtee [EMAIL PROTECTED] wrote:
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
6 matches
Mail list logo