What does your loop look like? Also, what do the where clauses in your 8
queries look like?
Could you post some code?
Mike
-----Original Message-----
From: Jim Louis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:45 AM
To: CF-Talk
Subject: reseting querys values in a loop
Hello,
I am running a loop and in it I have eight querys the are conditional
and I was wondering if there is a way to reset them to null after each
loop. What is happening is that I pick the first record it runs fine
then I pick the second record and if one of the querys is not processed
because the conditions are not met it keeps those values in play. and I
get record one's information in the record two's loop.
Ie
Record ID Roommate1.First Name
------------------------------------------
1 Jon
2 Jon (Should be blank)
3 Jackie
4 Jackie(Should be blank)
Thank you for your time
Jim
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
