The standard way is a cfparam.

-----Original Message-----
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Friday, 17 October 2003 11:21 a.m.
To: CF-Talk
Subject: passing empty form field entry

If a web site visitor completes a form without entering data in a field
(which in this case may be OK), how do you set up the coding for
inserting that "blank" entry into a database (or ignoring that field).  

If I include the field in the SQL insert statement, I get an error
"resolving parameter"

I'm trying to avoid a bunch of CFIF statements (ie. CFIF "field EQ '',
then such and such CFELSE such and such)

TIA
Tim


  _____  


[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to