dim aaa
aaa=request.form("myCustomerName")
if isnull(aaa) or aaa='' then
conn.execute "insert into customer(CustomerDate) values(null)"
else
conn.execute "insert into customer(CustomerDate) values('"&aaa&"')"
end if
aaa=request.form("myCustomerName")
if isnull(aaa) or aaa='' then
conn.execute "insert into customer(CustomerDate) values(null)"
else
conn.execute "insert into customer(CustomerDate) values('"&aaa&"')"
end if
所以要判断参数是否空,如果是空则存储null
例如:
dim aaa
aaa=request.form("myCustomerName")
if aaa="" then
conn.execute "insert into customer(CustomerDate) values('null')"else
conn.execute "insert into customer(CustomerDate) values('"&aaa&"')"
end if
end if