如题
一:是否已查询出来的结果,是不是我需要的。如果有这条记录就放行,请问后面的代码该如何写?
st = "select * from testpn where userid = ' & txtUserName & ' and ps =' & txtpassword & ' "
Set rs = New ADODB.Recordset
'rs.CursorLocation = adUseClient
rs.LockType = adLockReadOnly
rs.Open st, con二:我要查询的是二个条件,在FIND中是不允许这样做的,那我该如何才好呢?我要二个条件同时满足才会执行,,请问我该如果写。能不能给我实例给我。。谢谢!!!!
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.LockType = adLockReadOnly
rs.Open "testpn", con, 1, 3
rs.Requery
rs.MoveFirst
If rs.EOF = False Then
rs.Find "userid ='" & txtUserName & "'" [and "userid ='" & txtUserName & "'"]不允许
一:是否已查询出来的结果,是不是我需要的。如果有这条记录就放行,请问后面的代码该如何写?
st = "select * from testpn where userid = ' & txtUserName & ' and ps =' & txtpassword & ' "
Set rs = New ADODB.Recordset
'rs.CursorLocation = adUseClient
rs.LockType = adLockReadOnly
rs.Open st, con二:我要查询的是二个条件,在FIND中是不允许这样做的,那我该如何才好呢?我要二个条件同时满足才会执行,,请问我该如果写。能不能给我实例给我。。谢谢!!!!
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.LockType = adLockReadOnly
rs.Open "testpn", con, 1, 3
rs.Requery
rs.MoveFirst
If rs.EOF = False Then
rs.Find "userid ='" & txtUserName & "'" [and "userid ='" & txtUserName & "'"]不允许
If rs.eof then exit sub
二、
rs.filter = "userid ='" & txtUserName & "'" and "userid ='" & txtUserName & "'"
第一问,偶都不知道他在说什么,看来是偶的中文水平不行;
第二问,你肯定错的,Filter也不能双条件,这个偶以前遇到过的。
(LastName = 'Smith' OR LastName = 'Jones') AND FirstName = 'John'与之相反,可以构造如下形式的筛选:
(LastName = 'Smith' AND FirstName = 'John') OR (LastName = 'Jones' AND FirstName = 'John')
rs.Open "testpn", con, 1, 3
rs.Requery
rs.MoveFirst
If rs.EOF = False Then
rs.Filter = "userid =' “& txtUserName & ” ' and ps='“& txtpassword &”'"
yy = rs.RecordCount
xx = rs.AbsolutePosition
If xx < -1 Then
MsgBox "无法查找"
Else
yy = rs!ps
End If
End If
1: rs.Filter = "userid='yeling' and ps ='123456 '"(可以查询)
rs.Filter = "userid='"&txt&"' and ps ='&"txt1 "&'"(不行,变量如何表示?) 2: rs.Open "SELECT * FROM testpn " & "WHERE userid = ' txtusername ' And ps = 'txtpassword'", con, adOpenStatic, adLockReadOnly(这个也是,如果改为值便可以,如果用变量也查不到。该怎么表示)
维也纳,在那里,回答我啊
怎么是中文的双引号?英文双引号是字符串的边界,中文双引号是字符//rs.Filter = "userid='"&txt&"' and ps ='&"txt1 "&'"(不行,变量如何表示?)
&是连接符,两端要有空格,后面的子句不对,双引号的位置错了, 2:里面也写错了
概念不清啊!
&是连接符,两端要么是以双引号括起来的字符串,要么是变量,应该这么写:"SELECT * FROM testpn WHERE userid = '" & txtusername & "' And ps = '" & txtpassword & "'"