Error executing a cfquery update statement. PLEASE HELP

[murpg]

I have been over and over this. I am trying to update a simple table. I took
this script from the same server using a different DSN. I keep getting this
error.

Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access
Driver] Syntax error in UPDATE statement.

Here is the code.


<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfif IsDefined("FORM.MM_UpdateRecord") AND FORM.MM_UpdateRecord EQ "form1">

<cfquery datasource="#application.ds#">
UPDATE scrolltable SET ScrollerName=
<cfif IsDefined("FORM.scrollername") AND #FORM.scrollername# NEQ "">
'#FORM.scrollername#'
<cfelse>
NULL
</cfif>
, Text=
<cfif IsDefined("FORM.Text") AND #FORM.Text# NEQ "">
'#FORM.Text#'
<cfelse>
NULL
</cfif>
, Display=
<cfif IsDefined("FORM.Display") AND #FORM.Display# NEQ "">
#FORM.Display#
<cfelse>
NULL
</cfif>
WHERE CarID=#FORM.CarID#
</cfquery>
<cflocation url="index.cfm">
</cfif>
<cfif NOT IsDefined("FORM.MM_UpdateRecord")>
<cfquery name="Recordset1" datasource="#application.ds#">
SELECT *
FROM scrolltable
WHERE CarID = #url.CallerID#
</cfquery>
</cfif>
<!--- Set Document Title to be picked up in _header.html --->
<CFSET title = "Update #Recordset1.ScrollerName#">
<!--- Include style sheet --->
<CFINCLUDE TEMPLATE="../_header.html">
<form action="<cfoutput>#CurrentPage#</cfoutput>" name="form1" method="POST">
<table wCarIDth="100%" border="1" BORDERCOLOR="#DDDDCC">
<tr>
<th colspan="2" align="left" bgcolor="#F1F1EB" class="normal"
scope="col">Update <cfoutput>#Recordset1.ScrollerName#</cfoutput>&nbsp;</th>
</tr>
<tr>
<th scope="col" class="normal">Name:&nbsp;</th>
<th align="left" class="normal" scope="col"><input name="CarID"
type="hidden" value="<cfoutput>#Recordset1.CarID#</cfoutput>"><input
name="scrollername" type="text"
value="<cfoutput>#Recordset1.ScrollerName#</cfoutput>">&nbsp;</th>
</tr>
<tr>
<th scope="row" class="normal">Scroller Text:&nbsp;</th>
<td align="left" class="normal"><textarea name="Text" cols="70" rows="15"
wrap="virtual"><cfoutput>#Recordset1.Text#</cfoutput></textarea>&nbsp;</td>
</tr>
<tr>
<th scope="row" class="normal">Display Add:</th>
<td align="left" class="normal">Yes:
<input name="Display" type="radio" value="0" <cfif recordset1.Display EQ
0>checked<cfelse></cfif>>&nbsp; No: <input name="Display" type="radio"
value="1" <cfif recordset1.Display EQ 1>checked<cfelse></cfif>></td>
</tr>
<tr>
<th scope="row"><input name="" type="submit"></th>
<td><input name="" type="reset"></td>
</tr>
</table>

<input type="hidden" name="MM_UpdateRecord" value="form1">
</form>
<!--- Include footer --->
<CFINCLUDE TEMPLATE="../_footer.html">

[Mountain Lover]

"text" is a reserved word try using brackets around it....[Text]=
HTH

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

[murpg]

That is the answer.