问题:错误类型:Microsoft OLE DB Provider for SQL Server (0x80040E14)第 1 行: > 附近有语法错误。birthday=trim(Request.Form(day))&-&trim(Request.Form(month))&-&trim(Request.Form(year))birthday1=trim(Request.Form(day1))&-&trim(Request.Form(month1))&-&trim(Request.Form(year1)) if birthday<> or birthday1<> then sql=SELECT * FROM userxiaofei WHERE DateAndTime=>‘#&birthday&‘# AND DateAndTime <=‘#&birthday1&‘# order by dateandtime desc else sql=select * from userxiaofei order by dateandtime desc end if
呵呵..下次可不要把日期写成日月年了..咱们中国人可是年月日 如果你对错误类型:Microsoft OLE DB Provider for SQL Server (0x80040E14)第 1 行: > 附近有语法错误。birthday=trim(Request.Form(day))&-&trim(Request.Form(month))&-&trim(Request.Form(year))birthday1=trim(Request.Form(day1))&-&trim(Request.Form(month1))&-&trim(Request.Form(year1)) if birthday<> or birthday1<> then sql=SELECT * FROM userxiaofei WHERE DateAndTime=>‘#&birthday&‘# AND DateAndTime <=‘#&birthday1&‘# order by dateandtime desc else sql=select * from userxiaofei order by dateandtime desc end if这个问题有好的意见或
建议,请留言
|