> 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? MS SQL Server has a feature called an identity column, which will add a sequential numeric identifier to each record so you don't have to use a UUID. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com
