I have seen this behavior before under heavy load without using
transactions, but it did not happen every time like you are seeing.
An update will of course execute but not change the data if the where clause
does not match anything. If you can copy the same query into Query Analyzer
that shows in the debug and it updates where the cfquery did not, you might
want to try moving the query into a stored procedure. Since it works in sql
server, might as well keep it there ;-)
jon
----- Original Message -----
From: "JL" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 25, 2001 9:46 AM
Subject: CFQUERY Update......
> Hi all,
>
> I am trying to update a table using CFQUERY. I do not see any error when
the
> query is excuted in CF and I can see the query is correct in the debug
mode.
> But somehow the data is not updated. When I run the same query in SQL
Server,
> the data is updated. Does anybody know why? I am using CF 4.5 and SQL
Server
> 7.0
>
> The query is like this..
>
> UPDATE User
> SET newpassword = 'arenofun'
> WHERE ID = 1614
>
> Thanks in advance
>
> J
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
