I always create an unique field when I create a database table for the same reason. Normally, a table does not have a built-in way of identifying a unique record.
Luis -----Original Message----- From: Ed Gordon [mailto:NetDr@;callptc.com] Sent: Thursday, November 07, 2002 12:26 PM To: CF-Talk Subject: SQL UPDATE - identifying a record? 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
