Outputing all names in that group name..??

[snowboardr]

StrMID = "SELECT * FROM specs WHERE m_group=" & 1

rs = my_conn.Execute(StrMID)



m_group has two model names I want to output for that group, how would I do this?

If I just do Response.Write(rs("model_name&quot) it just prints out the first one in that group it comes to, and I want it to print out all of them with that group id..

Thanks in Advance..

Jason

 

[thegiraffe]

try doing

while not rs.eof
Response.Write(rs("model_name&quot)
rs.movenext
loop

hope this helps
Dave

Theres nothing worse than an idea when its the only one we have!