SELECT MAX(QuizDate) as QuizDate, QuizID,
QuizPercent = (SELECT MAX(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
On Wed, Mar 5, 2008 at 11:43 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] <[EMAIL
PROTECTED]> wrote:
> >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:
> >
> >>
>
> yes i am storing the time in the quiz date. i think it tends to throw the
> error if the quiz percent is the same.
>
> i checked the table and each entry has a unique id. would using that in
> the query solve it?
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:300626
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
