Is this code correct??? I am trying to check a record in one of my data
sources, is this records equals 0 then proceeds to win page, else goes to try
again page. I am trying the code below, but it automatically goes to the try
again page. Can anyone help me?
CODE:
<cfquery name="qWin" datasource="Winners">
SELECT Winner
FROM DailyWin
WHERE HuntId = <cfqueryparam cfsqltype="CF_SQL_NUMERIC"
value="#url.HuntId#">
</cfquery>
<cfif #qWin.Winner# EQUAL '0'>
<cfquery datasource="Winners">
UPDATE DailyWin
SET Winner = <cfqueryparam cfsqltype="CF_SQL_VARCHAR"
value="Winner">,
WHERE HuntId = <cfqueryparam cfsqltype="CF_SQL_VARCHAR"
value="#url.HunterId#">
</cfquery>
<cflocation
url
="YouWin.cfm?HuntId=#qHunt.HuntId#&PrizeId=#qPrize.PrizeId#&HunterId=#url.HunterId#"
addToken = "No">
<cfelse>
<cflocation
url
="TryAgain.cfm?HuntId=#qHunt.HuntId#&PrizeId=#qPrize.PrizeId#&HunterId=#url.HunterId#"
addToken = "No">
</cfif>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3455
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
