Syntax error in Where Statement

[Battle]

Having a problem with what the server says is a syntax error in the Where
statement, but cant figure out where it is.

<cfif IsDefined('URL.RecordID') OR IsDefined('Form.RecordID')>
<cfif IsDefined('URL.RecordID')>
<cfset RecordID=URL.RecordID>
<cfelse>
<cfset RecordID=Form.RecordID>
</cfif>
<cfelse>
<cfabort showerror="The RecordID must be passed to this template">
</cfif>
<cfif IsDefined('Form.RULES_Delete')>
<cfquery name="DeleteRecord" datasource="#Request.databaseA#" dbtype="ODBC">
DELETE FROM RULESID
WHERE ID=#variables.RecordID#
</cfquery>
<cfset Deleted=true>
</cfif>
<!--- inserted this into code to see if that changed the date to follow
fomat --->
<cfset DATE='#DateFormat("#Now()#", "mm/dd/yyyy")# #TimeFormat("#Now()#",
'hh:mm:sstt')#'>

<cfif IsDefined('Form.RULES_Edit')>
<cfquery name="UpdateRecord" datasource="#request.databaseA#" dbtype="ODBC">
UPDATE RULES
SET
NAME='#Form.NAME#',TEXT='#Form.TEXT#',EDITOR='#For m.EDITOR#',EDITOR_EMAIL='#Form
..EDITOR_EMAIL#',DATE='#Form.DATE#'
WHERE ID=#form.variables.RecordID# <---- is where the error occurs
</cfquery>
<cfset Updated=true>
</cfif>

<CFQUERY name="GetRecord" dataSource="mw4off" maxRows=1>
SELECT *
FROM RULES
WHERE ID = #variables.RecordID#
</CFQUERY>

Any help would be appreciated here.

Running windows 2003 server sp1 and Coldfusion Mx 7 server

Thanks

[Battle]

ok in the where statement above, the code should read

WHERE ID=#variables.RedordID#

[MikerRoo]

Try the attached code.



<cfif IsDefined('URL.RecordID') OR IsDefined('Form.RecordID')>
<cfif IsDefined('URL.RecordID')>
<cfset RecordID = Trim (URL.RecordID)>
<cfelse>
<cfset RecordID = Trim (Form.RecordID)>
</cfif>
<cfelse>
<cfabort showerror="The RecordID must be passed to this template">
</cfif>

<cfif IsDefined('Form.RULES_Delete')>
<cfquery name="DeleteRecord" datasource="#Request.databaseA#"
dbtype="ODBC">
DELETE FROM RULESID
WHERE ID=#variables.RecordID#
</cfquery>
<cfset Deleted=true>
</cfif>

<!--- inserted this into code to see if that changed the date to follow fomat
--->
<cfset DATE='#DateFormat("#Now()#", "mm/dd/yyyy")# #TimeFormat("#Now()#",
'hh:mm:sstt')#'>

<cfif IsDefined('Form.RULES_Edit')>
<cfquery name="UpdateRecord" datasource="#request.databaseA#"
dbtype="ODBC">
UPDATE
RULES
SET
NAME ='#Form.NAME#', <!--- "Text" will not scale!
Rename the column. --->
[TEXT] ='#Form.TEXT#', <!--- "Text" will not scale!
Rename the column. --->
EDITOR ='#Form.EDITOR#',
EDITOR_EMAIL ='#Form.EDITOR_EMAIL#',
<!--- XXXXXX Is Date stored as text or datetime?!?
Use the appropriate set statement.

[DATE] ='#Form.DATE#' <!--- "Date" is a reserve word!!
Rename the column. --->
--->
[DATE] =#CreateODBCDate (Trim (Form.DATE))#'
WHERE
ID=#variables.RecordID#
</cfquery>
<cfset Updated=true>
</cfif>

<CFQUERY name="GetRecord" dataSource="mw4off" maxRows=1>
SELECT *
FROM RULES
WHERE ID = #variables.RecordID#
</CFQUERY>