set rs=myconnsql.Execute ("select * from tabcard where approve=同意 and ReplyTime between " & rtime1 & " and " & rtime2 & " and pic like "&temppic&" order by num")
在sqlserver7.0下正常运行,但数据库换成sqlserver2000就不行了,说这句错,把and pic like "&temppic&" 改成and pic like %"&temppic&"%也不行,但运掉and pic like "&temppic&" 就可以 错在哪里??
http://www.eaoo.com/design/list.asp?classid=2&Nclassid=8
请问你的PIC的字段的类型。