You should validate it first, before you just send it to your stored procedure. If it is what you need, kick it back to the user, or at least set it to some default value.
<cfparam name="CustNo" default="-1" /> /Cody -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phillip Senn Sent: Thursday, March 02, 2006 2:11 PM To: [email protected] Subject: [CFCDev] OT: Empty fields passed as integer parameters If I pass an empty field into a stored procedure like so: <cfstoredproc procedure="myProcedure" datasource="#Application.DSN#"> <cfprocparam type="in" cfsqltype="cf_sql_integer" value="#FORM.CustNo#"> </cfstoredproc> I get: invalid data for cfsqltype cf_sql_integer. Is that right? What technique should I use? ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
