Actually he may be. (I'm sure using IN was also a problem, though)
I spent a couple of hours one afternoon trying to figure out what was wrong
with a
update query that looked like:
<cfquery ...>
UPDATE tbBlah
SET ...,
Currency = 'US',
...
WHERE...
</cfquery>
I kept getting a Syntax error. It turned out the problem was using a field
called Currency (I didn't realize Currency was a reserved word). The thing
that kept tripping me up was that in Access SELECT queries using Currency
worked fine, but the UPDATE query failed.
(I think one of my clients still has a database with a field called:
DamnBloodyField :) )
Another coder at my shop ran into the same problem when he called something
Date.
Dana
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
