One more thing about my previous message... If you're testing a text field instead of a radio button or checkbox, it WILL be defined so you don't have do the <CFIF></CFIF>. I believe it will just pass in an empty string.
What I sometimes do in those cases is test if the variable isDefined and pass in Null="yes" in the stored proc param if that field is left blank in the form.
<--- example --->
<CFIF isDefined("form.age")>
<CFPROCPARAM TYPE="IN" CFSQLTYPE=CF_SQL_INTEGER...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.