<% data_source_book = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("libros.mdb") Set con = Server.CreateObject("ADODB.Connection") con.Open data_source_book Response.Write "
" cadena = Request.QueryString("buscar") abece = Request.QueryString("abece") If cadena = "" Then strSQL = "SELECT * FROM libros ORDER BY autor" Elseif abece <> "" Then strSQL = "SELECT * FROM libros WHERE libros.autor LIKE '"&abece&"%' ORDER BY autor ASC" Else strSQL = "SELECT * FROM libros WHERE libros.autor LIKE '%"&cadena&"%' ORDER BY autor ASC" End If '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ sql = "SELECT DISTINCT autor FROM libros WHERE libros.autor LIKE '%"&inicial&"'" Set rs23 = Server.CreateObject("ADODB.Recordset") rs23.open sql, con, 3, 3 While Not rs23.EOF nombre_autor = rs23.Fields("autor") letrita = Mid(nombre_autor,1,1) If letrita <> letrita_sig Then Response.Write ""&letrita &" " End If nombre_autor = rs23.Fields("autor") letrita_sig = Mid(nombre_autor,1,1) rs23.MoveNext Wend rs23.Close Set rs23 = Nothing %>