>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:300611 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
