Question

帮帮忙！！asp日期查询

ss_date1=request(ss_date1)
ss_date1=request(ss_date1)
sql="select * from fp_info where fp_date between 'ss_date1' and 'ss_date2'"

标准表达式中数据类型不匹配。

改成：
sql="select * from fp_info where fp_date between 'ss_date1' and 'ss_date2'"
至少一个参数没有被指定值。
ss_date1=request("ss_date1")
ss_date2=request("ss_date2")

Answer 1

是什么数据库啊？

ss_date1=request(ss_date1)
ss_date1=request(ss_date1)
sql="select * from fp_info where fp_date between '"&ss_date1&"' and '"&ss_date2&"'"

ACCESS要加#
ss_date1=request(ss_date1)
ss_date1=request(ss_date1)
sql="select * from fp_info where fp_date between #"&ss_date1&"# and #"&ss_date2&"#"

Answer 2

String s = "dfdfsdf??dfsdf";
if (s.IndexOf("?") != -1)
{
Console.WriteLine("There has at least one ?");
}
else
{
Console.WriteLine("There isn't any ?");
}