where..like

[dream]

Hello ^^here is a picture of my database ********Code START**********<%@ LANGUAGE = vb script:cmdBack()" class="Menu1Title"> Precedente</a></td> </tr> </table></td> <td width="598"><%'if cd_cli = "" thenResponse.Write risposta'else'Response.Write risposta'end if%> </td> </tr></table>aa<br><a href="sheviprova.asp?user_id=<%=oRs("COD_NOTAIO")%>"><%=oRs("PA_NOME")%></a></body></html>********Code END**********In the nome = request.form("txtNome") when i search for "PA" It should show me 2 records but now it only shows me 1 and that is "PATRICK"Any help? y doesn't it show the asp code....

[Mr.Jay]

Hello ^^here is a picture of my database ********Code START**********<%@ LANGUAGE = vb script:cmdBack()" class="Menu1Title"> Precedente</a></td> </tr> </table></td> <td width="598"><%'if cd_cli = "" thenResponse.Write risposta'else'Response.Write risposta'end if%> </td> </tr></table>aa<br><a href="sheviprova.asp?user_id=<%=oRs("COD_NOTAIO")%>"><%=oRs("PA_NOME")%></a></body></html>********Code END**********In the nome = request.form("txtNome") when i search for "PA" It should show me 2 records but now it only shows me 1 and that is "PATRICK"Any help? y doesn't it show the asp code....

can you please post the sql statment.

[dream]

strSQL = "SELECT * FROM 000_REGISTRAZIONE WHERE COD_NOTAIO= '" & cd_cli & "' OR PA_NOME LIKE '%" & nome & "%'" 'strSQL = "SELECT * FROM 000_REGISTRAZIONE WHERE COD_NOTAIO= '" & cd_cli & "' OR PA_NOME LIKE 'PA*'" oConn.Execute strSQL oRs.open strSQL, oConn, 2, 3 'Response.write strSQL if (Not oRs.eof) then MaxCols = oRs.Fields.count for Col = 0 to MaxCols - 1 SetFieldValue "A" + oRs(Col).name, oRs(Col).value next Response.write oRs("COD_NOTAIO").value & " " & oRs("PA_NOME").value & "<br>" else risposta = "<span class='Menu1Title'>Il dati dei notaio richiestato non e stato trovato. </span>" end if

[dream]

i fixed it..Thanks