New Topic/Question
Reply
I've been trying to set up basic CF form, everytime i submit the information i get the following error:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
The error occurred in C:\inetpub\wwwroot\carsoupcorp.com\Questionnaire.cfm: line 86
84 : '#form.advertiserrelations#',
85 : '#form.onlinexp#',
86 : '#form.companyinterest#')
87 : </CFQUERY>
88 :
I've rebuilt the form, looked over it, checked spelling.. still cant figure out what's wrong. Here's what i've got for the coding:
<!---Here's the form table--->
<cfform action="questionnaire.cfm?action=submit" method="post">
<table width="200" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" height="100">
<div class="redHeadNews">QUESTIONNAIRE</div>
<CFIF Action IS "Submit">
<CFQUERY NAME="AddIt" DATASOURCE="#database#">
INSERT INTO leads2 (
fname,
address,
city,
state,
zip,
country,
phone,
franchisetype,
ifcontent,
ifbranding,
dealerrelations,
advertiserrelations,
onlinexp,
companyinterest,)
VALUES (
'#form.fname#',
'#form.address#',
'#form.city#',
'#form.state#',
'#form.zip#',
'#form.country#',
'#form.phone#',
'#form.franchisetype#',
'#form.ifcontent#',
'#form.ifbranding#',
'#form.dealerrelations#',
'#form.advertiserrelations#',
'#form.onlinexp#',
'#form.companyinterest#')
</CFQUERY>
<P>We've received your information and will follow up with you shortly.</p>
<CFELSE>
<P>Please provide your name, mailing address, email address, telephone number, and the company you represent. </p>
</CFIF>
</td>
</tr>
<tr>
<tr>
<TD width="66">Name: </td>
<TD width="183"><cfinput type="text" name="fname" required="yes" message="Please enter your full name."></TD>
<TD width="47"> </TD>
<TD width="192"> </TD>
</TR>
<TR>
<TD>Address:</td>
<TD><cfinput type="text" name="address" required="yes" message="Please specify a valid address."></TD>
<TD>City:</TD>
<TD><cfinput type="text" name="city" required="yes" message="Please specify your city."></TD>
</TR>
<TR>
<TD>State:</TD>
<TD><cfinput type="text" name="state" required="yes" message="Please select a state"></TD>
<TD>ZIP:</TD>
<TD><cfinput type="text" name="zip" required="yes" message="Please specify a valid zip code."></TD>
</TR>
<TR>
<TD>Country:</TD>
<TD><cfinput type="text" name="country" required="yes" message="Please specify your country."></TD>
<TD>Phone:</TD>
<TD><cfinput type="text" name="phone" required="yes" message="Please specify your phone number."></TD>
</TR>
<TR>
<TD COLSPAN="4">
<p>Type of franchise in which you are interested: <SELECT SIZE="1" NAME="franchisetype">
<option value=" "> </option>
<option value="Content">Content</option>
<option value="Branding">Branding</option>
</select><br />
<br />
If Content, please describe your connection with dealers in your market and the reasons why you believe that you can organize those dealers to participate in the CarSoup® Program.<br />
<cftextarea name="ifcontent" cols="50" rows="1"></CFTEXTAREA><br />
<br />
If Branding, please describe the media you control in your market, including any online portal sites.<br />
<cftextarea name="ifbranding" cols="50" rows="1"></CFTEXTAREA><br />
<br />
Please describe any prior experience you or your company has had in attempting to build strategic business relationships between dealer groups and media companies<br />
<cftextarea name="dealerrelations" cols="50" rows="1"></CFTEXTAREA><br />
<br />
Please describe any prior experience you or your company has had in attempting to build strategic business relationships with advertisers in the automotive category.<br />
<cftextarea name="advertiserrelations" cols="50" rows="1"></CFTEXTAREA><br />
<br />
Please describe any relevant online experience that you or your company has had.<br />
<cftextarea name="onlinexp" cols="50" rows="1"></CFTEXTAREA><br />
<br />
Please describe the reasons why you think that a CarSoup® franchise may be of interest to you or your company.<br />
<cftextarea name="companyinterest" cols="50" rows="1"></CFTEXTAREA>
<br />
<br />
<strong><i>The information contained on this site does not constitute an offer to sell a franchise. An offer of a franchise can only be made after delivery of a Franchise Disclosure document.</strong></i>
</p>
<p>Copyright 2011. CarSoup Franchising, LLC, 1401 East American Boulevard, Suite 6, Bloomington, MN 55425 </p>
</TD>
</TR>
<TR>
<TD COLSPAN="4"><div align="right"><BR/>
<input type="image" src="images/newsSubmitButton.jpg" alt="Submit"><br/><br/>
</div></TD>
</TR>
</TABLE>
</td>
</CFFORM>
<!---End Table--->
MultiQuote
| 