字符串变量输入sql数据库smalldatetime类型时，从字符串转换为smalldatetime时发生语法错误
在做一个ASP+SQL的课程设计

scome=request.form( "scomey ")& "- "&request.form( "scomem ") 'scomey为年，scome为月

conn.execute( "update   student   set   "&password& "   sname= ' "&sname& " ',sex= ' "&sex& " ',cla_id= "&cla_id& ",states= ' "&states& " ',scome= ' "&scome& " ',sout= ' "&sout& " ',scancel= ' "&scancel& " '   where   sid= "&request( "id ")& " ")

在网上找了好久资料都没有办法转换，比如加sname= '# "&sname& "# '

请大家帮下我，谢谢，

------解决方案--------------------
有年有月 但没有 日
scome=request.form( "scomey ")& "- "&request.form( "scomem ")& "- "&request.form( "scomed ") 'scomey为年，scome为月，scomed为日