Hi Adrian, Thank you so much for that suggestion, that's just what I needed.
I am an idiot. I was passing the same value to the "status" parameters. Of *course* there was no updating. Hardcoding the SQL showed me that. I didn't even have to run the SQL, it was obvious when I was writing in the second "status" value. Duh. I've made notes below: >Try hardcoding the SQL statement, so remove the cfqueryparam and place the >value you think is being passed in. > >Adrian > >-----Original Message----- >From: Teresa Robinson [mailto:[EMAIL PROTECTED] >Sent: 25 June 2007 17:01 >To: CF-Newbie >Subject: Re: Query works in SQL*Plus, not in CF >UPDATE test_view > SET status = > UPPER(TRIM(<cfqueryparam value="#arguments.status#" >cfsqltype="cf_sql_varchar">)) changed to <cfqueryparam value="#arguments.new_status#" ...> > WHERE test_id IN ( > SELECT test_ID > FROM test_VIEW > WHERE UPPER(TRIM(STATUS)) = > UPPER(TRIM( ><cfqueryparam value="#arguments.status#" >cfsqltype="cf_sql_varchar">)) changed to <cfqueryparam value="#arguments.old_status#" ...> > AND EXPIRE_DATE <= SYSDATE) ></cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2876 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
