Microsoft OLE DB Provider for SQL Server (0x80040E2F)
ÎÞ·¨½« NULL Öµ²åÈëÁÐ 'id'£¬±í 'blog.dbo.bigclass'£»¸ÃÁв»ÔÊÐí¿ÕÖµ¡£INSERT ʧ°Ü¡£
³öÎÊÌâµÄ´úÂëÊÇ£º
<%
Response.Buffer = True
Response.Expires = -1
Response.ExpiresAbsolute = Now() - 1
Response.Expires = 0
Response.CacheControl = "no-cache"
dim reback 'º¯Êý·µ»ØÖµ
'º¯Êý×÷ÓãºÑéÖ¤²éѯ¼Ç¼ÊÇ·ñ´æÔÚ
'²ÎÊý£º
'sql£º²éѯÓï¾ä
sub chkform(sql)
sql = sql
set rs = conn.execute(sql)
if not rs.eof then
reback = "1" 'µ±Îª1ʱ£¬ÓмǼ
else
reback = "2" 'µÈÓÚ2ʱ£¬Î޼Ǽ
end if
end sub
'º¯Êý×÷Ó㺸üÐÂÊý¾Ý±í¼Ç¼
'²ÎÊý£º
'sql£º²éѯÓï¾ä
'fields1£ºÐÞ¸Ä×Ö¶Î
'value1£º×Ö¶ÎÖµ
sub modirst(sql,fields1,value1)
set rs = server.CreateObject("adodb.recordset")
rs.open sql,conn,3,3
if isArray(fields1) = false then
rs(""&fields1&"") = value1
else
num = UBound(fields1) - 1
for i=0 to num
rs(""&fields1(i)&"") = value1(i)
Next
end if
rs.update()
reback = "1"
end sub
'º¯Êý×÷ÓãºÉ¾³ýÊý¾Ý
'²ÎÊý
'sql£ºÉ¾³ýÓï¾ä
sub delrst(sql)
set rs = server.CreateObject("adodb.recordset")
rs.open sql,conn,3,3
if not rs.eof then
rs.delete