Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by codr
-
Passing Parameters to Stored Procedures from Cold Fusion
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. -
Passing Parameters to Stored Procedures from Cold Fusion
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...
