Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-07 : 13:36:55
|
Jose writes "How can i make an query whith the expression like, it returns
null.
I´m using MsAcces 97 and Windows 2000. here is my code.
If IsObject(Session("DBSirhRed_conn")) Then
Set conn = Session("DBSirhRed_conn")
Else
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DBSirhRed","",""
Set Session("DBSirhRed_conn") = conn
End If
Vcliente= request.form("cliente")
sql = "select ncliente, nombre"
sql = sql & " from clientes"
sql = sql & " where nombre like '" & Vcliente & "*'"
sql = sql & " order by nombre"
Set rs_c = Server.CreateObject("ADODB.Recordset")
rs_c.Open sql, conn, 3, 3
could you tel me what´s wrong or if asp doesn´t supports
"like statement".
thanks
Jose" |
|
|
|
|
|
problesms with LIKE