i have this code:
Set Conn2 = Server.CreateObject("ADODB.Connection"
' conn.close
Conn2.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" & Server.MapPath("..\Data\maillist.mdb"
dim ssql
ssql = "select * from maillist where email = '" & request("uemail" & "';"
set rs = conn2.execute(ssql)
response.write ssql
response.write rs.recordcount
'--------------
The recordcount always gives me "-1" although there is an actual record... what is wrong here??
How can i see correctly when there is a record and when there are none?
Thanx,
Smarty
Set Conn2 = Server.CreateObject("ADODB.Connection"
' conn.close
Conn2.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" & Server.MapPath("..\Data\maillist.mdb"
dim ssql
ssql = "select * from maillist where email = '" & request("uemail" & "';"
set rs = conn2.execute(ssql)
response.write ssql
response.write rs.recordcount
'--------------
The recordcount always gives me "-1" although there is an actual record... what is wrong here??
How can i see correctly when there is a record and when there are none?
Thanx,
Smarty