If I understand correctly, you could save the original values for the
primary key (fields uniquely identifying the record) in variables and then
use those #variables# in your cfquery "WHERE" statement.
--Serge
----- Original Message -----
From: Miriam Hirschman <[EMAIL PROTECTED]>
To: CF Forum <[EMAIL PROTECTED]>
Sent: Thursday, June 01, 2000 11:13 AM
Subject: Update Query
How can I specify which row in my table I want to update if the user has the
ability to change every field. Is there any way besides making an autoNumber
field? I have an Access DB.
Thanks,
---miriam
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
