select * from outage where chinesename like ('%'+chinesename +'%') and (( starttime between starttime and finishedtime) or (finishedtime between starttime and finishedtime) )
sqlr="select * from outage where chinesename like ('%'+chinesename +'%') and (( starttime between '%"&starttime&"%' and '%"&finishedtime&"%') or (finishedtime between '%"&starttime&"%' and '%"&finishedtime&"%' ) ) "Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21' ODBC 驱动程序不支持所需的属性。 /outage/output1.asp,行28
put it in the asp or java application as a var. then do like this: in asp: response.write(varName); in java: System.out.println(varName); then check it if it order the SQL sy.
then do like this:
in asp:
response.write(varName);
in java:
System.out.println(varName);
then check it if it order the SQL sy.