Hi Allen,
<cfset playerShirt = 1>
<cfloop condition = "playerShirt lTE 10">
<cfquery datasource="#dsn#">
update team
set shirt = #playerShirt#
where ID = #playerShirt#
</cfquery>
<cfset playerShirt = playerShirt + 1/>
</cfloop>
This is presuming of course the players primary key is 1-10 so if
your primary key is a name for example you will have to query the
primary keys and loop that query using the primaryKey in the where
condition.
Paul
> <cfset playerShirt = 1>
>
> <cfloop condition = "playerShirt LTE 10">
> <cfquery name = "UpdateTeam" datasource = "#dsn#">
> Update Team
> set Shirt = #playerShirt#
> <cfset playerShirt = playerShirt + 1>
> </cfquery>
> </cfloop>
On 29/03/2008, at 2:20 AM, alan o'reilly wrote:
>> <cfset playerShirt = 1>
>>
>> <cfloop condition = "playerShirt LTE 10">
>> <cfquery name = "UpdateTeam" datasource = "#dsn#">
>> Update Team
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3513
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
