RE: nested loops/queries

2001-08-15 Thread xrussx
nt -Original Message- From: xrussx [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 5:03 PM To: CF-Talk Subject: nested loops/queries I'm having a weird problem doing a nested loop and a nested query. I have two queries. The topmenu query returns ids 1,2,3 and 4. The l

nested loops/queries

2001-08-15 Thread xrussx
I'm having a weird problem doing a nested loop and a nested query. I have two queries. The topmenu query returns ids 1,2,3 and 4. The leftmenu query returns ids 5,6,7,8,9 for topmenu.id=1 and 14,15,16 for topmenu.id=3. The queries are right and return the right data. For some reason when I'm