Well you would have to use all elements in the table which would make that record unique.
Most all tables I use have an ID number assigned using the IDENTITY seed. Thus I can easily update the record based on the ID field. Similar to the UUID but alot smaller. >>> [EMAIL PROTECTED] 11/07/02 01:26PM >>> How does one <CFQUERY> UPDATE a particular record on an SQL database? That is the general question... It may sound simple, but if you were to read a record using SELECT, if more than one record matched the criteria in a WHERE clause, how could you UPDATE just one of them? I have been using UUID on EVERY record in every table in order to alleviate this. It gives me a unique value for each record (row) and therefore I can say WHERE uuid='#the-uuid-I-read#' But without this technique - is there a record-number accessible or anything like that? Ed G. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
