ASP怎麼避免Insert資料時有空字串會出現錯誤
知識家有網友問 Here 怎麼避免Insert資料時有空字串會出現錯誤 只要加一個MM_IIf的Fuction就可以了 <% name = replace(trim(request("name")),"'","''") NEWS_PIC = replace(trim(request("NEWS_PIC")),"'","''") ' IIf implementation Function MM_IIf(condition, ifTrue, ifFalse) If condition = "" Then MM_IIf = ifFalse Else MM_IIf = ifTrue End If End Function set rs = server.createobject("adodb.recordset") sql = "INSERT INTO INDEX_NEWS(NEWS_PIC) VALUES('" & MM_IIF(NEWS_PIC, NEWS_PIC, null) & "')" 'response.write sql 'response.end cnn.Execute(sql) %>