[問題] 抓資料問題
我是個門外漢
目前遇到以下問題
Microsoft OLE DB Provider for ODBC Drivers 錯誤 '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]關鍵字 'where' 附近的語法不正確。
/rdcp_local/SQLconnection.asp, 列7
目的是從holidaytable中抓holiday欄位中的資料來比對
程式碼如下
strSql = "Select holiday from holidayTable order by holiday where holiday >" & sday & " and holiday <" & oday & ";"
response.write("Strsql="&strSql)
set rsUser = GetRs(StrSql,"Call_Report")
if not rsUser.length then
i=0
do while not rsUser.eof
i= i+1
rsUser.MoveNext
Loop
end if
Set rsUser = nothing
我不清楚where附近到底有什麼不對
用response.write("Strsql="&strSql)顯示
Strsql=Select holiday from holidayTable order by holiday where holiday >2010/2/23 and holiday <2010/3/20;
是因為抓不到holiday的值嗎?
--
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 218.32.67.194
→
02/23 16:32, , 1F
02/23 16:32, 1F
→
02/23 16:34, , 2F
02/23 16:34, 2F
→
02/23 16:34, , 3F
02/23 16:34, 3F
→
02/23 17:05, , 4F
02/23 17:05, 4F
推
02/23 20:45, , 5F
02/23 20:45, 5F
→
02/23 22:54, , 6F
02/23 22:54, 6F
→
02/23 22:55, , 7F
02/23 22:55, 7F