Do you have to use cfinsert? can you not insert via a normal <cfquery>?
On Sat, Jul 12, 2008 at 9:04 PM, John Barrett <[EMAIL PROTECTED]> wrote: > Hi Greg, > I am sorry, but I did use what you said, but I did not keep the > "form" in the cfinsert part, because that gave me the error" String > index out of range: -2" > I have never been able to figure out how to figure out how to write > nothing(a blank field) to a database incase a user just submits the > form without entering any data. > In the cfinsert I have tried "form.name" #form.name#" "'#form.name#'" > but I always get the same error?? > Thanks so much, > John > Below is my code. > > <!---form---> > <cfform action="actionpage.cfm" method="post"> > <table width="311" border="0"> > <tr> > <td>Name</td> > <td><cfinput type="Text" Name="name"></td> > </tr> > <tr> > <td>Email</td> > <td><cfinput type="text" name="email"></td> > </tr> > <tr> > <td>Receive in</td> > <td>Text <cfinput type="radio" name="EmailType" value="1">HTML > <cfinput type="radio" name="emailType" checked="true" value="0"></td> > </tr> > <tr> > <td></td> > <td><cfinput type="Submit" name="SubmitForm" > value="subscribe"></td> > </tr> > </table> > </cfform> > <!---actionpage---> > <cfparam name="form.name" default="" /> > <cfparam name="form.email" default="" /> > <cfparam name="form.emailType" default="0" /> > > <cfquery name="DupCheck" datasource="#REQUEST.dataSource#"> > SELECT * > FROM Newsletter > WHERE email = <cfqueryparam cfsqltype="cf_sql_varchar" > value="#Form.email#" /> > </cfquery> > > <!--- If our query shows a email match than using recordCount we can > tell the user that his email address already exists in our database ---> > <cfif DupCheck.recordCount GT "0"> > You are already Listed in our Mailing List! > <!--- If our recordCount is not greater than "0" we continue on > and process the new email address ---> > > <cfelse> > > <!--- Insert Member Information Into Database ---> > <cfinsert datasource="#REQUEST.dataSource#" > tablename="Newsletter" formfields="'#form.name#', '#form.email#', > '#form.emailType#'"> > > <cfoutput> > Thank you #Name#,<br /> > Your email address [#Email#] Has been entered into our > mailing list. You'll receive the next mailing! > </cfoutput> > > </cfif> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3821 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
