嘿嘿 大虾门解决下呵呵
shijian= "2007-6-12 "

我想把这个时间shijian 更新到JC_UserSalary_Days中
但是直接从查询中没有只有冲asp的参数中得到


SQL= "INSERT INTO JC_UserSalary_Days(UserName,Tbianma,ZZ,CreateDate)”
SQL=SQL & " Select b.username , B.Tbianma,b.zz， （这个地方怎么弄时间） "
SQL=SQL & " from (select ......) as b "



[解决办法]
shijian= "2007-6-12 "
SQL= "INSERT INTO JC_UserSalary_Days(UserName,Tbianma,ZZ,CreateDate)”
SQL=SQL & " Select b.username , B.Tbianma,b.zz, "
SQL=SQL & shijian
SQL=SQL & " from (select ......) as b "

[解决办法]
--时间要用 ' '扩起来

shijian= "2007-6-12 "
SQL= "INSERT INTO JC_UserSalary_Days(UserName,Tbianma,ZZ,CreateDate)”
SQL=SQL & " Select b.username , B.Tbianma,b.zz, "
SQL=SQL & " ' " & shijian & " ' "
SQL=SQL & " from (select ......) as b "