Does it return an error in CF?
Some thoughts:
Make sure that the ID field is a NUMBER field
and the ID # is unique.
-----Original Message-----
From: JL [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 9:46 AM
To: CF-Talk
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