SQL的Between...And...使用问题！

[poctopus]

在select语句中between #月/日/年# and #月/日/年# 就通过RS(0)显示数据。
但是使用“between sdata and edata ”Sdata、Edata已经定义，这些数据就是不能显示！！


<%
syear=request("s-year")
smonth=request("s-month")
sdate=request("s-date")
eyear=request("e-year")
emonth=request("e-month")
edate=request("e-date")

sdata="#"&smonth&"/"&sdate&"/"&syear&"#"
edata="#"&emonth&"/"&edate&"/"&eyear&"#"

dim conn
dim connstr
on error resume next
connstr="DBQ="+server.mappath("/database/cc.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr

rs=conn.execute ("select sum(cc_confirm),sum(cc_del),sum(cc_fmp),sum(cc_tsdd),sum(cc_ci),sum(cc_co) from zonghe where cc_date between sdata and edata")

%>




<%=rs(0)%>、<%=rs(1)%>、<%=rs(2)%>、<%=rs(3)%>、<%=rs(4)%>、<%=rs(5)%>

[loveweb]

rs=conn.execute ("select sum(cc_confirm),sum(cc_del),sum(cc_fmp),sum(cc_tsdd),sum(cc_ci),sum(cc_co) from zonghe where cc_date between sdata and edata")
+++++++++
try
rs=conn.execute ("select sum(cc_confirm),sum(cc_del),sum(cc_fmp),sum(cc_tsdd),sum(cc_ci),sum(cc_co) from zonghe where cc_date between '"&sdata&"' and '"&edata&"'")

[xieyj]

rs=conn.execute ("select sum(cc_confirm),sum(cc_del),sum(cc_fmp),sum(cc_tsdd),sum(cc_ci),sum(cc_co) from zonghe where cc_date between sdata and edata")
改成:
sql server 数据库:

rs=conn.execute ("select sum(cc_confirm),sum(cc_del),sum(cc_fmp),sum(cc_tsdd),sum(cc_ci),sum(cc_co) from zonghe where cc_date between '"&sdata&"' and '"&edata&"'")

access 数据库:
rs=conn.execute ("select sum(cc_confirm),sum(cc_del),sum(cc_fmp),sum(cc_tsdd),sum(cc_ci),sum(cc_co) from zonghe where cc_date between #"&sdata&"# and #"&edata&"#")

[银狐被占用]

rs=conn.execute ("select sum(cc_confirm),sum(cc_del),sum(cc_fmp),sum(cc_tsdd),sum(cc_ci),sum(cc_co) from zonghe where cc_date between sdata and edata")

换成：

rs=conn.execute ("select sum(cc_confirm),sum(cc_del),sum(cc_fmp),sum(cc_tsdd),sum(cc_ci),sum(cc_co) from zonghe where cc_date between "&sdata&" and "&edata)

[银狐被占用]

错了。
应该是：
rs=conn.execute ("select sum(cc_confirm),sum(cc_del),sum(cc_fmp),sum(cc_tsdd),sum(cc_ci),sum(cc_co) from zonghe where cc_date between '"&sdata&"' and '"&edata&"'")

[vvfish119]

rs=conn.execute ("select sum(cc_confirm),sum(cc_del),sum(cc_fmp),sum(cc_tsdd),sum(cc_ci),sum(cc_co) from zonghe where cc_date between #"&sdata&"# and #"&edata&"#")