sql插入空值null问题

[zhiye2005]

If instr(Request.Form("l_content"),"<img") > 0 or instr(Request.Form("l_content"),"<IMG") > 0 Then
list_pic_yn="1"
else
list_pic_yn=null
end if
解释：list_pic_yn是判断内容中是否有图片
然后再插入数据(部分字段省略)

sqltest="Insert into dbo.list_h(list_title,list_pic_yn)values('"&list_title&"','"&list_pic_yn&"')"

当用户提交的内容中没有图片时list_pic_yn=null 但是，它总是不能写入null值，sql此处的写入值为空
改为
sqltest="Insert into dbo.list_h(list_title,list_pic_yn,)values('"&list_title&"',"&list_pic_yn&")"
又不能正常的入库了

[claro]

[Quote=引用楼主 zhiye2005 的帖子:]

当用户提交的内容中没有图片时list_pic_yn=null 但是，它总是不能写入null值，…
[/Quote]

If instr(Request.Form("l_content")," <img") > 0 or instr(Request.Form("l_content")," <IMG") > 0 Then
list_pic_yn="1"
else
list_pic_yn is NULL
end if 

[claro]

--try？

[playwarcraft]

If instr(Request.Form("l_content")," <img") > 0 or instr(Request.Form("l_content")," <IMG") > 0 Then 
list_pic_yn="1" 
else 
list_pic_yn="null" 
end if 

sqltest="Insert into dbo.list_h(list_title,list_pic_yn,)values('"&list_title&"',"&list_pic_yn&")" 

[jinjazz]

sqltest="Insert into dbo.list_h(list_title,list_pic_yn)values('"&list_title&"',NULLIF('"&list_pic_yn&"',NULL))"

[htl258_Tony]

[Quote=引用楼主 zhiye2005 的帖子:]
If instr(Request.Form("l_content")," <img") > 0 or instr(Request.Form("l_content")," <IMG") > 0 Then
list_pic_yn="1"
else
list_pic_yn=null
end if
解释：list_pic_yn是判断内容中是否有图片
然后再插入数据(部分字段省略)

sqltest="Insert into dbo.list_h(list_title,list_pic_yn)values('"&list_title&"','"&list_pic_yn&"')"

当用户提交的内容中没有图片时list_pic_yn=null 但是，它总是不能写入…
[/Quote]

If instr(Request.Form("l_content")," <img") > 0 or instr(Request.Form("l_content")," <IMG") > 0 Then
list_pic_yn="1"
else
list_pic_yn is null
end if 

[playwarcraft]

你要把null也当字串 "null" 传进sqltest，才行哦，不然当然不能录入了。。。

[jinjazz]

上面手误
sqltest="Insert into dbo.list_h(list_title,list_pic_yn)values('"&list_title&"',NULLIF('"&list_pic_yn&"',''))"

[zhiye2005]

Microsoft VBScript 编译器错误 错误 '800a03ea'

语法错误

/inc/add_cmd.asp，行 17

list_pic_yn is NULL
------------^

[zhiye2005]

jinjazz
sqltest="Insert into dbo.list_h(list_title,list_pic_yn)values('"&list_title&"',NULLIF('"&list_pic_yn&"',''))"
正确！

[yygyogfny]

关注

[firefly_2008]

sqltest="Insert into dbo.list_h(list_title,list_pic_yn,)values('"&list_title&"',case when len('"&list_pic_yn&"')=0 then null else '"&list_pic_yn&"' end ) " 

[BS_somebody]

无满意答案，结贴！

[ChinaJiaBing]

If instr(Request.Form("l_content")," <img") > 0 or instr(Request.Form("l_content")," <IMG") > 0 Then
list_pic_yn="1"
else
list_pic_yn=null
end if

If instr(Request.Form("l_content")," <img") > 0 or instr(Request.Form("l_content")," <IMG") > 0 Then 
list_pic_yn="1" 
else 
list_pic_yn is null 

[mugua604]

sqltest="Insert into dbo.list_h(list_title,list_pic_yn,)values(isnull('"&list_title&"',''),isnull("&list_pic_yn&",''))"