> <CFQUERY datasource="xxx" DBTYPE="ODBC">
> UPDATE Ads
> SET online_approval = '2'
> WHERE ad_id = ad_id
> </CFQUERY>
Before I look any further, is this EXACTLY how the query is in your code?
The example you provided above is missing a variable in the query. The
ad_id = ad_id line should be more like ad_id = #ad_id#. At first glance
that COULD be the problem, although it could just have been a typo in the
example.
_______________________________________
Justin Scott :: [DtDNS Administrator]
http://www.dtdns.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
