Question

listview导出遇到空值出错该怎么办

Answer 1

import access;
import console;

//创建测试数据库
var db = access("/test123.mdb")
if(!db.existsTable("homepage") ){
db.exec("CREATE TABLE homepage (url char(30), comment char(20))")
}

//本来就支持null参数
var cmd = db.exec( "INSERT INTO homepage(url,comment) VALUES(@url,@comment)" ,{
["url"] = null;
["comment"] = "hi!";
} );

var cmd = db.exec( "INSERT INTO homepage(url,comment) VALUES(@url,@comment)" ,{
["url"] = "http://www.aau.cn";
["comment"] = "hi!";
} );

//查询 - 列出数据
for(rs,fields in db.each("select * from homepage") ){
console.log( rs("url").value,rs("comment").value )
}