Hi
I am getting this error message below from this code:
<CFQUERY NAME="updateText" DATASOURCE="#APPLICATION.dsn#" USERNAME="#APPLICATION.DB_UserName#" PASSWORD="#APPLICATION.DB_Password#" MAXROWS="1">
UPDATE #FORM.tName#
SET
Title = '#FORM.Title#', Content = '#FORM.content#', timeStmp = #CreateODBCDateTime(Now())#, modBy = #SESSION.userDet#
WHERE ID = #FORM.ID#
</CFQUERY>
-------------------------------------------------
Error Executing Database Query.
Syntax error (missing operator) in query expression 'text goes here'.
SET
Title = '#FORM.Title#', Content = '#FORM.content#', timeStmp = #CreateODBCDateTime(Now())#, modBy = #SESSION.userDet#
WHERE ID = #FORM.ID#</CFQUERY>
-------------------------------------------------
I really dont know why this wont work? It works for other sites that i have
Jennifer
I am getting this error message below from this code:
<CFQUERY NAME="updateText" DATASOURCE="#APPLICATION.dsn#" USERNAME="#APPLICATION.DB_UserName#" PASSWORD="#APPLICATION.DB_Password#" MAXROWS="1">
UPDATE #FORM.tName#
SET
Title = '#FORM.Title#', Content = '#FORM.content#', timeStmp = #CreateODBCDateTime(Now())#, modBy = #SESSION.userDet#
WHERE ID = #FORM.ID#
</CFQUERY>
-------------------------------------------------
Error Executing Database Query.
Syntax error (missing operator) in query expression 'text goes here'.
SET
Title = '#FORM.Title#', Content = '#FORM.content#', timeStmp = #CreateODBCDateTime(Now())#, modBy = #SESSION.userDet#
WHERE ID = #FORM.ID#</CFQUERY>
-------------------------------------------------
I really dont know why this wont work? It works for other sites that i have
Jennifer