Have you tried surrounding the "job_id" with brackets such that: Update jobs set status=0 where [job_id]=1
Perhaps, and I'm only stabbing in the dark here, job_id becomes a reserved word when submitting certain types of statements to your DBMS (where they might become jobs)? Try it and see. Cheers, Kris > 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> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:247771 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
