Phillip Senn said the following on 3/2/2006 4:10 PM: > 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? > Try:
<cfprocparam type="in" cfsqltype="cf_sql_integer" value="#FORM.CustNo#" null="#YesNoFormat(NOT Len(form.CustNo)))#" /> .Peter -- Peter J. Farrell :: Maestro Publishing Member Team Mach-II :: Member Team Fusion http://blog.maestropublishing.com Create boilerplate beans and transfer objects for ColdFusion! Fire up a cup of Rooibos! http://rooibos.maestropublishing.com/ ---------------------------------------------------------- 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]
