When you store the date, are you also storing the time? I would think if you put the time in there that you could not have the problem because even if doing the test back to back there would be a seconds difference.
On Wed, Mar 5, 2008 at 10:21 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > hi, i have the following query that retrieves the latest quiz date and > quiz percent > > SELECT MAX(QuizDate) as QuizDate, QuizID, > QuizPercent = (SELECT QuizPercent FROM Test_Board_Acupuncture as t1 > WHERE t1.Customer_ID = #COOKIE.TCMTests# > AND t1.QuizID = Test_Board_Acupuncture.QuizID > AND t1.QuizDate = > MAX(Test_Board_Acupuncture.QuizDate)) > FROM Test_Board_Acupuncture > WHERE Customer_ID = #COOKIE.TCMTests# > GROUP BY QuizID > > the problem is that if the student takes the same test back to back right > away somteimes it can throw an error from the sub query > > Diagnostics: Error Executing Database Query. [Macromedia][SQLServer JDBC > Driver][SQLServer]Subquery returned more than 1 value. This is not > permitted when the subquery follows =, !=, <, <= , >, >= or when the > subquery is used as an expression. > > is there a way of restructuring the query so that i can select the info > without it triggering the error? > > thank you. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-Talk/message.cfm/messageid:300610 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
