L
lzwboyss
Unregistered / Unconfirmed
GUEST, unregistred user!
用asp插入一段文字到oracle中,字段设置varchar2(3000),实际word统计不到1400字符,但是无法提交,没反应!
实际情况是,单位主页信息公告览发布的信息不够长.长了无法保存到oracle中去!请问高手什么原因?
<%
function sqlstr(data)
sqlstr="'"& replace(data,"'","''"
& "'"
end function
subject=request("subject1"
detail=request("detail"
inputdate=request("inputdate"
if subject=""
or detail=""
or inputdate=""
then
response.write "<title>Sorry!提交失败</title>"
response.write "<body bgcolor=lightgreen>"
response.write "<br><br><center> 字段空白不接受!</center>"
response.end
end if
set conn=server.createobject("adodb.connection"
conn.open "dsn=info"
sql="insert into Information (Info_Subject,Info_Detail,Info_InputDate) values("
sql=sql & sqlstr(subject) & ","
sql=sql & sqlstr(detail) & ","
sql=sql & sqlstr(inputdate) & ""
conn.execute sql
%>
实际情况是,单位主页信息公告览发布的信息不够长.长了无法保存到oracle中去!请问高手什么原因?
<%
function sqlstr(data)
sqlstr="'"& replace(data,"'","''"
& "'"end function
subject=request("subject1"
detail=request("detail"
inputdate=request("inputdate"
if subject=""
or detail=""
or inputdate=""
then
response.write "<title>Sorry!提交失败</title>"
response.write "<body bgcolor=lightgreen>"
response.write "<br><br><center> 字段空白不接受!</center>"
response.end
end if
set conn=server.createobject("adodb.connection"
conn.open "dsn=info"
sql="insert into Information (Info_Subject,Info_Detail,Info_InputDate) values("
sql=sql & sqlstr(subject) & ","
sql=sql & sqlstr(detail) & ","
sql=sql & sqlstr(inputdate) & "
"conn.execute sql
%>