Help me I have been working all day trying to get thisUpdate Query to work

[murpg]

I am getting this error when I try and run this query update.

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

The error occurred in
E:\Domains\theautogalleryva.com\wwwroot\MyCFSite\h tml\scroller\update_scroller_a
ction.cfm: line 23

21 : NULL
22 : </cfif>
23 : WHERE CarID = #FORM.CarID#
24 : </cfquery>
25 : <cflocation url="index.cfm">




--------------------------------------------------------------------------------

SQL UPDATE scrolltable SET ScrollerName = 'Cross Lander' , Text = 'The
Crosslander 2005 Coming Soon' , Display = 1 WHERE CarID = 1
DATASOURCE AGMyCFSite
VENDORERRORCODE -3503
SQLSTATE 42000

Here is my 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>

<form action="<cfoutput>#CurrentPage#</cfoutput>" name="form1" method="POST">
<table width="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>

[The ScareCrow]

Text and possibly Display are reserved words and you should not have a column
with these names
either rename the columns or enclose in square brakets

UPDATE scrolltable
SET ScrollerName = 'Cross Lander'
, [Text] = 'The Crosslander 2005 Coming Soon'
, [Display] = 1
WHERE CarID = 1

Ken