Terry,
I have had the same problem -- it usually happens when you are using a query
variable from a loop inside a nested loop. Set the first loop query
variable to a temp variable to use in your nested loop. e.g:
SELECT *
FROM tbl_node
WHERE node_id IN
(
SELECT node_id
FROM tbl_mission_comm
If I understand what you're saying, I had something similar to this a little
while ago. Don't pull all your hair out ;-) The only way I found to work
around my loop within a loop problem was to set a variable in the outer loop
= to the value I needed to use in the inner loop. Then use this new var
2 matches
Mail list logo