这个代码错在什么地方？

[frankhuai]

set myRs=myConn.Execute("select cardsid from shoppercard where fidshopper='"&session(idshopper)&"'")




strSQL1="insert into paybill (cardnumberid,paybillitemid,jf,df,workman,fidorder) values((myrs"cardsid"),1,0,4000,111,"&_idOrder &")"

set rs=myConn.Execute(strSQL1)

[ttt2]

strSQL1="insert into paybill (cardnumberid,paybillitemid,jf,df,workman,fidorder) values("&myrs("cardsid")&",1,0,4000,111,"&_idOrder &")"

[firstsee]

第二个语句(myrs"cardsid")是什么意思

[possible_Y]

strSQL1="insert into paybill (cardnumberid,paybillitemid,jf,df,workman,fidorder) values("&myrs("cardsid")&",1,0,4000,111,"&_idOrder &")"


还要注意你的字段的类型，如果是非数字型的要加单引号

[zxll5523613]

同上