yea, doh, i misread what you wrote in your first email, sorry =) -----Original Message----- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 14 November 2001 1:32 p.m. To: CF-Talk Subject: RE: SQL INSERT
If the text input is left blank on the form then when it is passed to the action page is has a value of "" Since it has a value the <cfparam> is not kicking in. I would have to write logic like Bryan mentioned. <cfif form.numberVar3 IS ""><cfset form.numberVar3 = "NULL"></cfif> none of the radio buttons or check boxes are numbers. They are text. At 01:20 PM 11/14/2001 +1300, you wrote: >so you're saying when you don't select a checkbox then it's setting the var >to "" ? > >-----Original Message----- >From: Chad Gray [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, 14 November 2001 1:19 p.m. >To: CF-Talk >Subject: RE: SQL INSERT > > >So such luck. Since the form is defining the var to "" the <cfparam ... >default="0"> is not taking effect. > >Guess i will just have to write the <CFIF> logic that Bryan was talking >about. This sucks since i have about 30 inputs to check. > >Thanks everyone! > > > >At 07:11 PM 11/13/2001 -0500, you wrote: > >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
