帮帮忙!!asp日期查询

来源:百度知道 编辑:UC知道 时间:2024/05/27 12:37:14
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")

是什么数据库啊?

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&"#"

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