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.
