请帮忙看看"and"附近有啥错误？

[frankrenping]

下面代码有报错：
在关键字 'and' 附近有语法错误。

/asp/matchwith.asp，行 10


<!--#include file="conn/conn.asp"-->
<%
dim Gender1,age1,age2,country,drrTmp
Gender1=request.QueryString("Gender")
age1=request.QueryString("age1")
age2=request.QueryString("age2")
country=request.QueryString("country")
set rs=server.createobject("adodb.recordset")
sql="select Username,Gender,age,Country from customer1 where Gender='"&Gender1&"'and (age BETWEEN "+age1+" and "+age2+") and Country ='"&country&"'"
rs.open sql,conn,2,3
if rs.eof and rs.bof then
response.write("no one match with you want! please try again!")
else
for i=1 to rs.recordcount
if rs.eof then
exit for
end if
drrTmp=drrTmp&rs("Username")&","
session("eeee")=drrTmp
rs.movenext
next
end if
%>
<%
dim hrrTmp
hrrTmp=replace(session("eeee"),",","','")
set rs=server.createobject("adodb.recordset")
sql="select ID,USERNAME,PICPATH from ladlady where USERNAME in ('"&hrrTmp&"')"
rs.open sql,conn,1,3
if rs.eof and rs.bof then
response.Write("no photo!")
else
Do while not rs.eof
str=rs("PICPATH")
rs.movenext
loop
end if
rs.close
set rs = nothing
str=escape(str)
Response.Write str
set conn=nothing
%>

[APM60-]

第1个and前加个空格，“+”换成“&”试试

sql="select Username,Gender,age,Country from customer1 where Gender='" & Gender1 & "' and (age BETWEEN " & age1 & " and " & age2 & ") and Country ='" & country & "'"

[liuwei_IT_love]

sql="select Username,Gender,age,Country from customer1 where Gender='"&Gender1&"'and (age BETWEEN "&age1&" and "&age2&") and Country ='"&country&"'"

[sy_binbin]

sql="select Username,Gender,age,Country from customer1 where Gender='"&Gender1&"' and (age BETWEEN "&age1&" and "&age2&") and Country ='"&country&"'"

这样试试

[frankrenping]

1楼，2楼 都一样的报错

[frankrenping]

age1,age2 是INT 类型是空值

下面两句是不是要改呢？

age1=request.QueryString("age1")
age2=request.QueryString("age2")

[beyond_me21]

if age1<>"" and age2<>"" then
sql="select Username,Gender,age,Country from customer1 where Gender='"&Gender1&"'and (age BETWEEN "+age1+" and "+age2+") and Country ='"&country&"'"
else
sql="select Username,Gender,age,Country from customer1 where Gender='"&Gender1&"'and Country ='"&country&"'"
end if

[frankrenping]

age1,age2都有默认值：20，40
不能用条件判断的。

[frankrenping]

[Quote=引用 5 楼 frankrenping 的回复:]
age1,age2 是INT 类型是空值

下面两句是不是要改呢？

age1=request.QueryString("age1")
age2=request.QueryString("age2")
[/Quote]

对不住，把大家搞糊涂了，这里说age1,age2 是空值指的是在这个MATCHWITH.ASP 里显示空值，它们本身在另一页面中有默认值20，40，不知为啥传掉了。

[beyond_me21]

那你在里有age1=request.QueryString("age1")
age2=request.QueryString("age2")
重新给它们赋值了，如果url参数是空值，它们也不会变成默认值的
改成
if age1="" then
age1=20
else
age1=request.QueryString("age1")
end if
if age2="" then
age2=40
else
age2=request.QueryString("age2")
end if

[beyond_me21]

if request.QueryString("age1")="" then
age1=20
else
age1=request.QueryString("age1")
end if
if request.QueryString("age2")="" then
age2=40
else
age2=request.QueryString("age2")
end if

[Dogfish]

还以变量不符合要求。

[frankrenping]

可以用上面的代码，没报错，谢谢。

[Rotel-刘志东]

sql="select Username,Gender,age,Country from customer1 where Gender='"&Gender1&"'and (age BETWEEN "&age1&" and "&age2&") and Country ='"&country&"'"

[一把编程的菜刀]

数值不能用单引号