关于在select * from .....中只用变量的问题

[immc1979]

这样写有什么错误

dim keyword
dim aaa
dim size

keyword="aa.txt"

Set rs = Server.CreateObject("ADODB.Recordset")
strSQL ="SELECT * FROM file where filename like '%"&keyword&"%' ORDER BY filesize DESC"
rs.open strSQL,Conn,3,3
aaa=rs("filename")

Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.open "SELECT * FROM CACHINFO where FILENAME ="&aaa,conn,3,3 <-问题出在这里吧,应该怎么写?
size=rs1("filesize")

[immc1979]

各位高手关注一下呀！！！

[jiffer]

rs1.open "SELECT * FROM CACHINFO where FILENAME ='"&aaa&"'",conn,3,3 <-问题出在这里

[whghwujx]

sqlstr="SELECT * FROM CACHINFO where FILENAME ="&aaa
rs1.open sqlstr,conn,3,3
或者
rs1.open "SELECT * FROM CACHINFO where FILENAME ='"&aaa&"'",conn,3,3

[QCB181]

同意楼上的

[qzriso]

FILENAME 是不是字符型的，如果是：
rs1.open "SELECT * FROM CACHINFO where FILENAME ='"&aaa&"'",conn,3,3

[skyboy0720]

同意！

[immc1979]

各位前辈，显示Provider 错误 '80020005' 类型不匹配。

[driftarter]

数据库连接方式有问题，你贴出来分析

[immc1979]

dim conn
set conn=server.createobject("ADODB.connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=192.168.0.1;UID=mydat;PWD=123456;DATABASE=db3000"

dim keyword
dim aaa
dim size

keyword="aa.txt"

Set rs = Server.CreateObject("ADODB.Recordset")
strSQL ="SELECT * FROM file where filename like '%"&keyword&"%' ORDER BY filesize DESC"
rs.open strSQL,Conn,3,3
aaa=rs("filename")

Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.open "SELECT * FROM CACHINFO where FILENAME ="&aaa,conn,3,3 <-问题出在这里吧,应该怎么写?
size=rs1("filesize")

[try52000]

dim keyword
dim aaa
dim size

keyword="aa.txt"

Set rs = Server.CreateObject("ADODB.Recordset")
strSQL ="SELECT * FROM file where filename like '%"&keyword&"%' ORDER BY filesize DESC"
rs.open strSQL,Conn,3,2


Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.open "SELECT * FROM CACHINFO where FILENAME ='"& rs("filename") &"'3,2 size=rs1("filesize")

[try52000]

对不起，错了
dim keyword
dim aaa
dim size

keyword="aa.txt"

Set rs = Server.CreateObject("ADODB.Recordset")
strSQL ="SELECT * FROM file where filename like '%"&keyword&"%' ORDER BY filesize DESC"
rs.open strSQL,Conn,3,2


Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.open "SELECT * FROM CACHINFO where FILENAME ='"& rs("filename") &"',3,2 size=rs1("filesize")

[try52000]

对不起，有错了
dim keyword
dim aaa
dim size

keyword="aa.txt"

Set rs = Server.CreateObject("ADODB.Recordset")
strSQL ="SELECT * FROM file where filename like '%"&keyword&"%' ORDER BY filesize DESC"
rs.open strSQL,Conn,3,2


Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.open "SELECT * FROM CACHINFO where FILENAME ='"& rs("filename") &"'",3,2 size=rs1("filesize")

[immc1979]

还是返回“类型不匹配”：（

[diveas]

rs1.open "SELECT * FROM CACHINFO where FILENAME ="&aaa&"",conn,3,3

[diveas]

rs1.open "SELECT * FROM CACHINFO where FILENAME ='"&aaa&"'",conn,3,3
应该把''去掉吧。
rs1.open "SELECT * FROM CACHINFO where FILENAME ="&aaa&"",conn,3,3

[qihboy]

不应该把''去掉.去掉就错了.

[immc1979]

dim conn
set conn=server.createobject("ADODB.connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=192.168.0.1;UID=mydat;PWD=123456;DATABASE=db3000"
这里select到的记录不是唯一的，有问题么？

总是提示“类型不匹配”