aspÖнøÐÐoracleµÄupdate²»Äܳɹ¦ - Web ¿ª·¢ / ASP
<%
If Request.Form("mySubmit") = "Modify" Then
total = i
for i=1 to total
rbb = Request.Form("rbb"& i )
guanxz=Request.Form("guanzx"& i )
names=Request.Form("names"& i)
strSql="Update code_tank Set rbb="& rbb &" where names='"+names+"' "
'strSql="Update code_tank set rbb='"&rbb&"',guanxz='"+guanxz+"' where names='"+names+"' "
conn.execute(strSql)
Next
response.redirect Request.ServerVariables("HTTP_REFERER")
conn.close
Set conn = nothing
End If
End If
%>
Ö»ÄÜÐÞ¸ÄÒ»¸ö,µ«¸ü¸Ä2¸ö±äÁ¿Ê±¾Í»á³ö´í
µÚÒ»¸östrSqlÄÜÖ´Ðгɹ¦,µÚ¶þ¸ö²»ÄÜÖ´ÐгöÏÖ´íÎó:
Microsoft OLE DB Provider for Oracle ´íÎó '80004005'
ORA-01407: cannot update ("GUANXZ") to NULL
rbb = Request.Form("rbb"& i )
guanxz=Request.Form("guanzx"& i )
names=Request.Form("names"& i)
ÔõôÄܷŵ½Ñ»·ÍâÃæÑ½
Ïà¹ØÎÊ´ð£º
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
ÍòÍøµÄ·þÎñÆ÷Ö§³Öα¾²Ì¬µÄ,Ö±½ÓÓÃrewriteÔÚweb.configÎļþд¹æÔò,Ò²²»Óð²×°×é¼þ¾Í¿ÉÒÔʵÏÖα¾²Ì¬,µ«ÊÇÔÚʱ´ú»¥Áª·þÎñÆ÷¾ÍÓò»ÁËÁË,×ÉѯËüµÄ¿Í·þ,Ëû˵ËûÃÇ·þÎñÆ÷(»ù±¾ÐÍC)²»Ö§³Öα¾²Ì¬µÄ.ÇëÎÊһϸ÷λÎÒ¸ÃÓÃʲô·½·¨ ......
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£
ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£
ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£
ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......
ÎÒÓÐÁ½¸ödropdownlist¶¼°óºÃÁËÖµ£¬ÏëÑ¡ÖÐÒ»¸ödropdownlistÖеÄÖµ£¬È»ºóÔÚÁíÒ»¸ödropdownlistÖÐÑ¡ÖÐÏàÓ¦µÄÒ»Ïî¡£
²»ÊÇ´Óа󶨵ڶþ¸ödropdownlist£¬ÊÇÔÚÒѾ°óºÃµÄÖµµ±ÖÐÑ¡ÖÐÒ»¸ö¡£
ÎÒÏëÓÃjsд
ÇóÖú
Äã¿ÉÒÔ°Ñdrop ......