how do i do this?<BR>If only one result comes up in the search i want to redirect to that page, as opposed to showing the results for only one match.<BR>heres my code, is it close? by the way, go easy, i&#039m an apprentice geek...<BR><BR>&#060;% <BR>sSearch = Request.QueryString("q") <BR>images = "/images/"<BR>Counter = 0<BR><BR>set conn = Server.CreateObject("ADODB.Connection")<BR>conn.op en "monkey"<BR><BR>Set cArtist = conn.Execute("select * from Artist WHERE ArtistName LIKE &#039%" & sSearch & "%&#039 ORDER BY ArtistName")<BR><BR>do while not cArtist.eof<BR>cArtist.movenext<BR>Counter = Counter + 1<BR>Loop<BR><BR>If Counter = "1" then<BR>Response.Write (Counter)<BR>else<BR>%&#062;<BR><BR>&#060;%do while not cArtist.eof%&#062;<BR>&#060;b&#062;&#060;a class="link" href="/artist/default.asp?id=&#060;%=cArtist("ArtistID")%&#062;" &#062;<BR>&#060;%=cArtist("ArtistName")%&#062;&#06 0;/a&#062;&#060;/b&#062;<BR><BR>&#060;%=(Mid(cArtist("ArtistBio"),1 ,130))%&#062;...&#060;p&#062;<BR>&#060;%=counter%& #062;<BR>&#060;%cArtist.movenext<BR>Loop%&#062;<BR ><BR><BR>&#060;%end if%&#062;