Some of them are.... i will try this. Thanks.
At 01:03 PM 11/14/2001 +1300, you wrote:
>The fields that you're inserting into wouldn't happen to be number fields
>would they?
>
>if so you might want to do <cfparam name="form.var" default="0">
>
>-----Original Message-----
>From: Chad Gray [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, 14 November 2001 12:50 p.m.
>To: CF-Talk
>Subject: SQL INSERT
>
>
>This seems like such a beginner question, but can you use INSERT INTO with
>form fields that are left blank? ( i am using <cfparam name="form.var"
>default=""> for the radio buttons, and check boxes on the action page )
>
>Im getting a "Syntax error in INSERT INTO statement". THe statement works
>fine if all the fields in the form are filled out. If i submit the form
>with all blanks i get this error.
>
>The resulting SQL statement looks something like this on the action page:
>
>SQL =
>INSERT INTO products (FILENAME,DIM,CONFIG)
>VALUES ('',,'')
>
>This is with a MS Access database also.
>
>DO i have to have to do:
>INSERT INTO products (<CFIF form.var is not "">FILENAME</CFIF>)
>VALUES (<CFIF form.var is not "">#form.filename#</CFIF>)
>
>I hope not!
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
