setting database columns as individual variables

[phentalmyst]

hello all!

pretty much what i'm trying to do is do a standard sql query, like so:

<%
groover = Request.Querystring(&quot;groover&quot

SQL=&quot;SELECT groover, name, email, influences, justin, brian, joel, kris, nishan FROM bios Where groover=&quot;&amp;groover
set member = conn.Execute(SQL)

%>

what i want to be able to do is set the individual guys (ie email, joel, etc) as their own variables for elseif statements and im not really sure how to do this.

any help is greatly appreciated!

thanks!