What happens when you try to do a delete statement that you know will fail
(so you don't delete data):
DELETE FROM
jobs
WHERE
job_id != job_id
This should never be true, but I am curious as to if it throws the same
error.
.......................
Ben Nadel
www.bennadel.com
-----Original Message-----
From: Scott Mulholland [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 26, 2006 1:16 PM
To: CF-Talk
Subject: RE: Odd Query issue
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:247779
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
