I would suggest doing a simple query against the database:
<cfquery name="AnsCheck" datasource="Hunts">
SELECT A1, A2, A3, A4, A5, A6, A7, A8, A9, A10
FROM DailyHunt
</cfquery>
I am assuming that there is only 1 record in this table, if not,then qualify
the query to the row that you wanted.
Then I would suggest 'looping' through to find out which ones are wrong.
<cfset wronganswers="">
<cfloop from="1" to="10" index="i">
<cfif.ansfild#i# neq anscheck.a#i#>
<cfset listappend('wronganswers', i)>
</cfif>
</cfloop>
Than you can check the wronganswers variable to see if there are wrong
answers and return them to the user as you prefer.
Hope this helps,
William
::-----Original Message-----
::From: Frank Velazquez [mailto:[EMAIL PROTECTED]
::Sent: Friday, March 21, 2008 1:53 PM
::To: CF-Newbie
::Subject: Validation and Forms
::
::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#&Hun
::terId=#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:3480
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
