if accute=1 then //accute表示是否模糊查询
OP="LIKE '%" & 变量 & "%'"
else
OP="='" & 变量 & "'"
end ifsqlstr="Select * from 表名 where 字段名 "&OP&" and left(pubdate,4) between datefrom and dateto "
OP="LIKE '%" & 变量 & "%'"
else
OP="='" & 变量 & "'"
end ifsqlstr="Select * from 表名 where 字段名 "&OP&" and left(pubdate,4) between datefrom and dateto "
OP="LIKE '%" & 变量 & "%'"
else
OP="='" & 变量 & "'"
end ifsqlstr="Select * from 表名 where 字段名 "&OP&" and left(pubdate,4) between '" & datefrom & "' and '" & dateto & "'"
OP="LIKE '"
else
OP="= '"
end if
sqlstr="Select * from 表名 where 字段名 " & OP & 变量 & "' and left(pubdate,4) between datefrom and dateto "
OP="LIKE '"
else
OP="= '"
end if
sqlstr="Select * from 表名 where 字段名 "&OP&" and left(pubdate,4) between '" & datefrom & "' and '" & dateto & "'"
OP="LIKE '%" & 变量 & "%'"
else
OP="='" & 变量 & "'"
end ifsqlstr="Select * from 表名 where 字段名 "&OP&" and left(pubdate,4) between datefrom and dateto "
OP="LIKE '%" & 变量 & "%'"
else
OP="='" & 变量 & "'"
end ifsqlstr="Select * from 表名 where 字段名 " & OP & " and left(pubdate,4) between '" & datefrom & "' and '" & dateto "'"
if accute=1 then //accute表示是否模糊查询
OP="LIKE '%" & 变量 & "%'"
else
OP="='" & 变量 & "'"
end ifsqlstr="Select * from 表名 where 字段名 "&OP&" and left(pubdate,4) between datefrom and dateto "应该考虑多个变量和字段名的时候