※ 引述《molucolin (molucolin)》之銘言：
: If Request("txtBeginDate") <> "" And Request("txtEndDate") <> "" then
: sql="Select * from Database where Date between Request("txtBeginDate")
: and Request(txtEndDate)"
: End if
: 在 sql 雙引號內 要如何加入單引號
程式碼怪怪的...
試試:
sql = "Select * from Datebase where Date between '" & _
Request("txtBeginDate") & "' and '" & _
Request("txtEndDate") & "'"
如果試過了記得上來回一下啊~
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 220.229.61.172