Is there a simple way of only updating one record?
<cfquery datasource="#SiteDatasource#" maxrows="1">
update Werewolf_Players
set Role = 2
where Role = 0
and gameid = #check.GameID#
order by Rand()
</cfquery>
I thought the maxrows would work, but apparently not.
Any ideas without me having to build an array or anything to complicated
(I'm trying to toss this up in a day or so, so I don't have time to get
super complicated).
Is there any way of updating just 1 record randomly when all the record
fields are the same?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313227
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
