asp 中sql语句select的一种应用，不知错在那了？

[soar_ocean]

set connsql=Server.CreateObject("adodb.connection")
connstr= "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("courthouse.mdb")
dim sqlStr
sqlStr="select * from ktgg_message where datetime like '"&year1&"*'"
set rs1=connsql.Execute(sqlStr)
要实现从courthouse.mdb中ktgg_message表中查询datetime字段，
利用like '"&year1&"*'" 匹配的记录
datetime 中类型为xxxx-xx-xx日期型,year1为字符型xxxx 的年
请高手们帮帮忙，不胜感激。

[希偌]

把datetime的类型改为字符型就可以了

[donotbesilent]

应该这样:
sqlStr="select * from ktgg_message where Year(datetime)=" & year1

[ehom]

想用统配符是吗?不是*是%
sqlStr="select * from ktgg_message where datetime like '"&year1&"%'"
当然
sqlStr="select * from ktgg_message where year(datetime)="&year1更好!

[hawkeyes]

应是sqlStr="select * from ktgg_message where datetime like '%"&year1&"%'"

[wzheng]

记住在ASP中，％代表任意多个任意字符，？代表1个任意字符。

[lihaitaoami]

非字符型数据怎么能用like匹配？
如果是点日期判断的话，用year()=year() and month()=month().....的方式；
如果是段日期判断的话，用datetime与convert(datetime,year1+'-'+month1+'-'+day1)进行判断。

[soar_ocean]

这有一种有些笨的方法
sqlStr="select * from ktgg_message where datetime between #"+"1/1/"+year1+"# and #"+"12/31/"+year1+"#"

[keliangui]

应该这样:
sqlStr="select * from ktgg_message where Year(datetime)='"& year1 &"'"