Unexplained ColdFusion Error Plz Help!!

[joeman77]

I keep getting the following error each time I attempt to add a recordset to a
database using an insertion form created in Dreamweaver, this is for a very
important company project and I have tried everything that I know of to fix the
problem with no luck, if someone out there cold please help me and tell me what
is going on I would appericate that very much, what follows is a copy of the
error I am getting and the code of the site I am working on, Thank you in
advance for your kind help.

This is Error I keep getting when I submit the form on my site:

"<Error Occurred While Processing Request

Error Executing Database Query.
Syntax error in INSERT INTO statement.



Please try the following:
? Enable Robust Exception Information to provide greater detail about the
source of errors. In the Administrator, click Debugging & Logging > Debugging
Settings, and select the Robust Exception Information option.
? Check the ColdFusion documentation to verify that you are using the correct
syntax.
? Search the Knowledge Base to find a solution to your problem.

Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; AT&T CSM7.0; SV1;
..NET CLR 1.0.3705)
Remote Address 127.0.0.1
Referrer [url]http://localhost:8500/dynamic/XBOX%20Slave.cfm?recordID=9[/url]
Date/Time 25-Sep-05 10:21 PM>"




And this is the Code of the site from Dreamweaver:

<cfparam name="URL.ID" default="1">
<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">
<cfquery datasource="sitedrive">
INSERT INTO INPUTSITE (SELECT, FIRSTNAME, LASTNAME, BADDRESS, BCITY,
BSTATE, BZIPCODE, EMAIL, BPHONE, SHIPFIRSTNAME, SHIPLASTNAME, SHIPADDRESS,
SHIPCITY, SHIPSTATE, SHIPZIP, CCARD, MM, YYYY, CVVNUM, TYPE)
VALUES (
<cfif IsDefined("FORM.SELECT") AND #FORM.SELECT# NEQ "">
'#FORM.SELECT#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.FIRSTNAME") AND #FORM.FIRSTNAME# NEQ "">
'#FORM.FIRSTNAME#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.LASTNAME") AND #FORM.LASTNAME# NEQ "">
'#FORM.LASTNAME#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.BADDRESS") AND #FORM.BADDRESS# NEQ "">
'#FORM.BADDRESS#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.BCITY") AND #FORM.BCITY# NEQ "">
'#FORM.BCITY#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.BSTATE") AND #FORM.BSTATE# NEQ "">
'#FORM.BSTATE#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.BZIPCODE") AND #FORM.BZIPCODE# NEQ "">
'#FORM.BZIPCODE#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.EMAIL") AND #FORM.EMAIL# NEQ "">
'#FORM.EMAIL#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.BPHONE") AND #FORM.BPHONE# NEQ "">
'#FORM.BPHONE#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.SHIPFIRSTNAME") AND #FORM.SHIPFIRSTNAME# NEQ "">
'#FORM.SHIPFIRSTNAME#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.SHIPLASTNAME") AND #FORM.SHIPLASTNAME# NEQ "">
'#FORM.SHIPLASTNAME#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.SHIPADDRESS") AND #FORM.SHIPADDRESS# NEQ "">
'#FORM.SHIPADDRESS#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.SHIPCITY") AND #FORM.SHIPCITY# NEQ "">
'#FORM.SHIPCITY#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.SHIPSTATE") AND #FORM.SHIPSTATE# NEQ "">
'#FORM.SHIPSTATE#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.SHIPZIP") AND #FORM.SHIPZIP# NEQ "">
'#FORM.SHIPZIP#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.CCARD") AND #FORM.CCARD# NEQ "">
'#FORM.CCARD#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.MM") AND #FORM.MM# NEQ "">
'#FORM.MM#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.YYYY") AND #FORM.YYYY# NEQ "">
'#FORM.YYYY#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.CVVNUM") AND #FORM.CVVNUM# NEQ "">
'#FORM.CVVNUM#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.TYPE") AND #FORM.TYPE# NEQ "">
'#FORM.TYPE#'
<cfelse>
NULL
</cfif>
)
</cfquery>
<cflocation url="Thanks.html">
</cfif>
<cfquery name="Recordset2" datasource="sitedrive">
SELECT *
FROM XBOX
WHERE ID = #URL.ID#
</cfquery>
<cfquery name="Recordset1" datasource="sitedrive">
SELECT *
FROM XBOX
WHERE ID = #URL.recordID#
</cfquery>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Thank You For Your Purchase!!!</title>
</head>

<body>
<table border="0" align="center">
<cfoutput>
<tr>
<td width="74">ItemName:</td>
<td width="153">#Recordset1.ItemName#</td>
</tr>
<tr>
<td>Platform:</td>
<td>#Recordset1.Platform#</td>
</tr>
<tr>
<td><div align="center"></div></td>
<td><div align="center"><img
src="C:\CFusionMX7\wwwroot\Dynamic\Images\#Records et1.Image#" align="top"
/></div></td>
</tr>
<tr>
<td>Category:</td>
<td>#Recordset1.Category#</td>
</tr>
<tr>
<td>Price:</td>
<td>#Recordset1.Price#</td>
</tr>
</cfoutput>
</table>

<p>&nbsp;</p>
<p>&nbsp;</p>

<form method="post" name="form1"
action="<cfoutput>#CurrentPage#</cfoutput>">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">FIRSTNAME:</td>
<td><input type="text" name="FIRSTNAME" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">LASTNAME:</td>
<td><input type="text" name="LASTNAME" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Billing Address</td>
<td><input type="text" name="BADDRESS" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">CITY:</td>
<td><input type="text" name="BCITY" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">STATE:</td>
<td><input type="text" name="BSTATE" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">ZIPCODE:</td>
<td><input type="text" name="BZIPCODE" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">EMAIL:</td>
<td><input type="text" name="EMAIL" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Contact PHONE:</td>
<td><input type="text" name="BPHONE" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Shipping Address (If Different from Above):
</td>
<td>&nbsp;</td>
</tr>
<tr valign="baseline">
<td nowrap align="right">FIRSTNAME:</td>
<td><input type="text" name="SHIPFIRSTNAME" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">LASTNAME:</td>
<td><input type="text" name="SHIPLASTNAME" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Shipping ADDRESS:</td>
<td><input type="text" name="SHIPADDRESS" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">CITY:</td>
<td><input type="text" name="SHIPCITY" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">STATE:</td>
<td><input type="text" name="SHIPSTATE" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">ZIP Code:</td>
<td><input type="text" name="SHIPZIP" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Please Enter Payment Information </td>
<td>(We Only Accept Visa &amp; Mastercard at this time) </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Credit Card Number (No Spaces):</td>
<td><input type="text" name="CCARD" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">EXP Month</td>
<td><input type="text" name="MM" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">EXP Year</td>
<td><input type="text" name="YYYY" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">CVV Value (3-Digit number on back of your
Card):</td>
<td><input type="text" name="CVVNUM" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Comments or Special Instructions: </td>
<td><textarea name="TYPE" cols="30" rows="10"></textarea></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">&nbsp;</td>
<td><input type="submit" value="Submit">
<label>
<input name="Clear" type="reset" id="Clear" value="Reset" />
</label></td>
</tr>
</table>
<input type="hidden" name="SELECT"
value="<cfoutput>#Recordset1.ItemName#</cfoutput>">
<input type="hidden" name="MM_InsertRecord" value="form1">
</form>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>

<p>&nbsp;</p>
</body>
</html>

[mxstu]

If you are using Access, "Type" is a , .... etc)

[Mountain Lover]

SELECT is a reserved word in any database...probably type also (as mxstu
pointed out)
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

[mxstu]

>SELECT is a reserved word in any database..

Yes, that is what meant. That "type" is a reserved word in access (maybe in
other databse). Key sql words like "select" (update, insert, etc) would be
reserved in any database. Hence the I comment "I <bold>strongly</bold>
recommend changing..." that column. Sorry if that wasn't clear :-)

[Mountain Lover]

more likely, us news readers don't see half of those lovely html
post...and I'm stubborn and don't want all the flash stuff...so it's
much easier though newsgroups...just that these forums don't show us
newsgroup users all of the message ;-(

On 9/28/2005 11:43 AM mxstu intelligently wrote:

>>SELECT is a reserved word in any database..

>
> Yes, that is what meant. That "type" is a reserved word in access (maybe in
> other databse). Key sql words like "select" (update, insert, etc) would be
> reserved in any database. Hence the I comment "I <bold>strongly</bold>
> recommend changing..." that column. Sorry if that wasn't clear :-)
>

--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

[Mountain Lover]

this is all that came across in the newsgroup message:

If you are using Access, "Type" is a

that's it!!!!
They shouldn't offer the newsgroup option if it doesn't work right!!! RSS
would be much nicer! ;-)

[mxstu]

Well that's not good at all ;-) I know that "modifications" to posts aren't
usually visible to NG users, and that extraneous formatting like bold, italics,
etc doesn't show up. I didn't realize the links got messed up as well. The
full message was:

>If you are using Access, "Type" is a reserved word. "Select" is definitely a

reserved

>word. Try changing the column names to something else (preferred) or using
>square brackets around the column in the INSERT statement. I would strongly
>recommend changing the column named "Select".

I think the problem is that "reserved word" was a hyperlink to a page on the
MS site listing reserved words for Access. It must have cut off the rest of the
text.