大家来看一看极简单的问题,抢分啊!

[appleboyallen]

代码如下
strSql="insert into temp (ID,Name) values (numId,strName)"
conn.execute strsql
其中numId,strName 都是变量,可是这样总是抱错,请问该怎么写这句话呢?

[fy_eyas]

strSQL ="insert into temp(ID, name) values(" & str(numId) & "," & str(strName) &")"
变量不能直接写入到字符串内，需要转换以下变量类型

[appleboyallen]

其实应该是这样的strSQL ="insert into temp(ID, name) values('" & numId & "','" & strName &"')"