This may seem silly but did you pop this into query analyzer (assuming this is MS SQL...I didn't see you mention what database it is). I have found that when you get odd errors like this back from a query sometimes they are misreporting the error...if you try it in query analyzer you may get a clearer error message. My guess is the problem lies in the word satus and not in job_id...so try bracketing that keyword (which btw using Query Analyzer will highlight potential keyword conflicts for you too). Hope that helps.
- Brian Rinaldi blog - http://www.remotesynthesis.com/blog CF Open Source List - http://www.remotesynthesis.com/cfopensourcelist Boston CFUG - http://www.bostoncfug.org On 7/26/06, Scott Mulholland <[EMAIL PROTECTED]> wrote: > > I tried with a qryparam yesterday, no change. Selecting job_id from jobs > works as well. > > If I run select * from information_schema.columns where table_name = > 'jobs' > the column comes back as well. > > This is one of those weird "it worked fine for yrs up until yesterday and > nothing in the code or table changed" things. I'm thinking something is > corrupt in the database. > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 26, 2006 12:32 PM > To: CF-Talk > Subject: Re: Odd Query issue > > What happens if you put it into a cfqueryparam? > > What happens if you select job_id from jobs? > > > > > > > > "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, > Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, > Registered in England, Number 678540. It contains information which is > confidential and may also be privileged. It is for the exclusive use of > the > intended recipient(s). If you are not the intended recipient(s) please > note > that any form of distribution, copying or use of this communication or the > information in it is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the sender or > call > our switchboard on +44 (0) 20 89107910. The opinions expressed within > this > communication are not necessarily those expressed by Reed Exhibitions." > Visit our website at http://www.reedexpo.com > > -----Original Message----- > From: Scott Mulholland <[EMAIL PROTECTED]> > To: CF-Talk <[email protected]> > Sent: Wed Jul 26 17:42:27 2006 > Subject: RE: Odd Query issue > > 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:247783 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
