Errr...that's the main purpose of a primary key. Generally a unique value for each record. Without it, you run into...well, the problem you're describing.
> -----Original Message----- > From: Ed Gordon [mailto:NetDr@;callptc.com] > Sent: Thursday, November 07, 2002 1: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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
