Query problem

[kloner]

Hi all,

When I have a query and am looping through it to find the groupname for a username, I want to somehow 'Break' the query for that user. For example looking at the data below if I am searching for 'members' I don't want the query to continue once 'members' has been found. I want it to stop at the first record where we find 'members' and not continue. How would I do this?


DB Example....
username groupname
Matt members
Matt admin
Matt other
Matt sysadmin

[sig]<p>Matthew Wall<br><a href=mailto: > </a><br><a href= > </a><br> [/sig]

 

[gasparrelli]

MAatt, you could try creating a variable before your loop starts, changing that variable when the loop finds your matching record, and setting the loop to only run as long as the variable is the original value. In other words, have your loop look at the variable and exit the loop when the variable changes. Does that help your situation? Or could you just use a simple select statement instead of looping through records? [sig][/sig]