ASP,SQL,关于一个数字型数据的写入
ccc的赋值是数字型
ccc数据表行的属性是数字型
sqlstr= "insert into nnn(aaa,bbb,ccc)values( ' "&aaa& " ', ' "&bbb& " ',***) "
ccc是数字型,***处要怎么表达?
[解决办法]
"&量名& "
[解决办法]
insert into nnn(aaa,bbb,ccc)values( ' "&aaa& " ', ' "&bbb& " ', "&ccc& ")
[解决办法]
数字型和其他的唯一区别是不用加单引号
[解决办法]
sqlstr= "insert into nnn(aaa,bbb,ccc)values( ' "&aaa& " ', ' "&bbb& " ', "&aaa& ") "