Another SQL problem

[billy_good]

I'm getting "Syntax error in UPDATE statement." on the following, any ideas? It
was working fine in CF4.5

CF 6.1 says the error is here;
where id='#form.cvid#'

<cfquery name="insert_bullets" datasource="#ds#" dbtype="ODBC">
update CV_Static
set OFFICE_ID='#form.office_id#',
LANG='#form.LANG#',
FIRST_NAME='#form.first_name#',
M_INITIAL='#form.m_initial#',
LAST_NAME='#form.last_name#',
PHONE_BUS='#form.phone_bus#',
PHONE_FAX='#form.phone_fax#',
EMAIL='#form.email#',
TITLE_E='#form.title_e#',
TITLE_F='#form.title_f#',
IMAGE_ALIGN='#form.image_align#',
VIEWED=#sa#,
AGENCY_SERVICE=#aa#,
see_vcard=#va#
<cfif form.image IS NOT "">,image='#file.serverfile#'</cfif>
<cfif form.vcard IS NOT "">,vcard='#file.serverfile#'</cfif>
where id='#form.cvid#'
</cfquery>

[GUKLLY]

do you try to change it this way...??


<cfif form.image NEQ "">,image='#file.serverfile#'</cfif>
<cfif form.vcard NEQ "">,vcard='#file.serverfile#'</cfif>

[CF_Oracle]

What value was actually passed from #form.cvid#?
What ID format is in database?
If numeric then it will be error when you passed non-numeric data.
Use in query where id=#form.cvid# (without single quotes) or better
<CFQUERYPARAM value="#form.cvid#" CFSQLType = "CF_SQL_NUMERIC">

[The ScareCrow]

As this worked in 4.5
I would suggest that the query is erroring on
EMAIL='#form.email#',

or

VIEWED=#sa#,

I would say either one or both are reserved words.

Ken

[CF_Oracle]

ScareCrow, none of these words are reserverd in MX 6.1. See: [url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/express4.htm[/url]

[The ScareCrow]

No, but they could be in the new drivers ?

Besides, I think you will find that "Email" would probably be in most db's

Ken

[CF_Oracle]

Not reserved in CF7 :
[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=p art_cfm.htm[/url]
Not in Oracle, Access, MySQL.