I just wrote these two tests and ran them, same result...the select works, the update gives "Invalid column name 'job_id'."
<cfquery name="testSelect" datasource="#request.dsnName#"> Select * from jobs where job_id = 1 </cfquery> <cfquery name="testSelect" datasource="#request.dsnName#"> Update jobs set status = 0 where job_id = 1 </cfquery> Scott -----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 3:02 PM To: CF-Talk Subject: RE: Odd Query issue Can you actually post the CFQuery codes so we can see if maybe there is something you are not seeing. ........................ Ben Nadel www.bennadel.com -----Original Message----- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 25, 2006 1:23 PM To: CF-Talk Subject: Odd Query issue I have a query today that stopped working with an invalid column error. The database did not change. Select statements work on it but not updates. Select * from jobs where job_id = 1 - works fine Update jobs set status = 0 where job_id = 1 - results in Invalid column name 'job_id'. Any ideas what would cause this to just start happening? Thanks, Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247768 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
