I hate bothering you guys, but I have noone else I could ask.
I am working on this questionaire thing which checks answers inputed by the
user with already stored answerd in my database, right now I have it set up so
that is the answer does not match the one I have in my db it tells the user "on
or more of your answers is wrong" what I want to do now is Specify which answer
is the one that is wrong, because it becomes frustrating to the user when they
don't know which one they have wrong, either by making the worng answer red or
showing a warning window like I have. this is my code:
<!--- Aster the form has been submited--->
<cfif isDefined ("form.AnsFild1")>
<cfquery name="AnsCheck" datasource="Hunts">
SELECT A1, A2, A3, A4, A5, A6, A7, A8, A9, A10
FROM DailyHunt
WHERE A1 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild1#">
AND A2 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild2#">
AND A3 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild3#">
AND A4 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild4#">
AND A5 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild5#">
AND A6 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild6#">
AND A7 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild7#">
AND A8 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild8#">
AND A9 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild9#">
AND A10 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild10#">
</cfquery>
<cfif AnsCheck.RecordCount>
<!--- HUNTER ANSWER HUNT CORRECTLY - Places usr answers in db
--->
<!--- HUNTER's Answers are stored in DB --->
<cfquery datasource="Hunters">
UPDATE DailyHntr
SET AnsFild1 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild1#">,
AnsFild2 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild2#">,
AnsFild3 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild3#">,
AnsFild4 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild4#">,
AnsFild5 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild5#">,
AnsFild6 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild6#">,
AnsFild7 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild7#">,
AnsFild8 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild8#">,
AnsFild9 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild9#">,
AnsFild10 = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.AnsFild10#">,
DateHuntPlayed = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.DateHuntPlayed#">,
TimeHuntPlayed = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.TimeHuntPlayed#">,
HuntId = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#url.HuntId#">,
PrizeId = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#url.PrizeId#">,
HuntSaveURL = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR"
value="LevelCleared.cfm?HuntId=#qHunt.HuntId#&PrizeId=#qPrize.PrizeId#&HunterId=#url.HunterId#">,
HunterIp = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#CGI.REMOTE_ADDR#">,
HunterBrsr = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#CGI.HTTP_USER_AGENT#">
WHERE PlayerNumber = <cfqueryparam
cfsqltype="CF_SQL_VARCHAR" value="#FORM.PlayerNumber#">
</cfquery>
<!--- HUNTER ANSWERED QUESTIONS CORRECTLY, SENDING TO WINNING
PAGE --->
<cflocation
url
="LevelCleared.cfm?HuntId=#qHunt.HuntId#&PrizeId=#qPrize.PrizeId#&HunterId=#url.HunterId#"
addToken = "No">
<cfelse>
<!--- HUNTER DID NOT ANSWER HUNT CORRECTLY -
REDIRECTING TO HUNT PAGE --->
<script language="Javascript">
alert ("ATTENTION! One or more of your answers were
incorrect. Please review your answers and try again. Thank you!")
</script>
<!---FORM IS SHOWN AGAIN FOR USER TO COMPLETE--->
</cfif>
Thanks, sorry for bothering you so much!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:3479
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
