aspÒ»¸öSQL²Ù×÷µÄÎÊÌ⣬¸üÐÂ×Ö¶ÎʱÓÃ×ֶα¾Éí
Çë¿´Ò»ÏÂÎÒҪʵÏÖÕâ¸öЧ¹û£¬Ó¦¸ÃÈçºÎ´¦ÀíÄØ£¿
conn.execute("update table set ziduan="&chengxu(ziduan,bianliang)&" where id=1")
¾ÍÊÇ˵£¬ÎÒÒª¸üеÄÊÇ¡°ziduan¡±Õâ¸ö×ֶΣ¬¶ø¡°chengxu(²ÎÊý1,²ÎÊý2)¡±ÓÖÊÇÒ»¸öasp¹ý³Ì(Óõ±Ç°µÄÄÚÈݼÓÉÏеÄÄÚÈÝ)£¬¶¼ÊÇ×Ö·ûÐÍÊý¾Ý£¬ÓÐûÓа취ʵÏÖÄØ£¿
Function chengxu(c1,c2)
c3=c1&c2
chengxu=c3
End function
bianliang="1,2,3"
aaa=chengxu(ziduan,bianliang)
ÕâÑùÀ´´úÌæ
ºÃÏñ²»ÄÜÕâô¸ÉµÄ°É
strsql="select zhiduan from table where id=1"
set rs = dbconn.execute(strsql)
if not(rs.eof and rs.bof) then
strsql="update table set ziduan="&chengxu(rs("zhiduan"),bianliang)&" where id=1"
end if
ÉÙдÁËÕâÒ»¾ä
dbconn.execute strsql
ÓÃ3Â¥µÄ·½·¨Êµ¼ÊÉÏÊǽøÐÐÁËÒ»´Î²éѯºÍÒ»´Î¸üУ¬ÎÒÖ÷ÒªÊÇÏëʵÏÖÖ±½Ó¸üеIJÙ×÷£¬²»ÖªµÀÓÐûÓа취¡£
ÕâÑùÊDz»Ðеİɣ¡
ÄãÏȰÑchengxu(ziduan,bianliang)¸³¸øÒ»¸ö±äÁ¿£¡
˳±ãÔÙÇë½ÌÒ»ÏÂ
rs=server.createobject("adodb.recordset")
sql="select * from table"
rs.open conn,1,1
do while not rs.eof
rs1=server.createobject("adodb.recordset")
sql1="select * from table2 where id="&rs(id)&""
if rs1.eof then
conn.execute("update table set......")
else
end if
rs1.close
set rs1=nothing
rs.movenext
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
<part name="bstrPnrNO" type="s:string" />
<part name ......
Microsoft JET Database Engine '80040e07'
±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£
\wwwroot\update.asp, line 20
--------------------------------------------------------------------------------
Ho ......
ÎÒÏëʵÏÖÒ»¸öЧ¹ûÊÇ£ºÄܰÑÒ³Ãæ·Ö³É¼¸¸ö´ó¿é£¬µãÏ´ó¿éÉϵÄ+±ãÕ¹¿ª£¬µãÏÂ-±ãÕÛµþ¡£
Õâ¸öÓÐʲô¿Ø¼þ¿ÉÒÔÓò»£¬Çë¸ßÊÖ²»Áߴͽ̣¡
ÓÃjs´úÂëÀ´ ¿ØÖÆ divµÄ¶¯×÷´Ó¶øÄÜʵÏÖ
js¿ØÖÆdivÏÔʾ/Òþ²ØÁË
VS2008×Ô´ø·â×°Á ......