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]
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]