Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

ÔÚasp.netÀïÃæ½Å±¾³ö´í - .NET¼¼Êõ / ASP.NET

function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;

var div1=document.getElementById("divPwd");

if (pwd.value=="")
{
......

asp µ÷ÓÃjavaдµÄwebservice - Web ¿ª·¢ / ASP

ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
  <part name="bstrPnrNO" type="s:string" /> 
  <part name ......

asp³õѧÎÊÌâ - Web ¿ª·¢ / ASP

Microsoft JET Database Engine '80040e07' 
±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£ 
\wwwroot\update.asp, line 20
--------------------------------------------------------------------------------
Ho ......

asp.net ÖÐÕÛµþЧ¹ûÈçºÎʵÏÖ - .NET¼¼Êõ / ASP.NET

ÎÒÏëʵÏÖÒ»¸öЧ¹ûÊÇ£ºÄܰÑÒ³Ãæ·Ö³É¼¸¸ö´ó¿é£¬µãÏ´ó¿éÉϵÄ+±ãÕ¹¿ª£¬µãÏÂ-±ãÕÛµþ¡£
Õâ¸öÓÐʲô¿Ø¼þ¿ÉÒÔÓò»£¬Çë¸ßÊÖ²»Áߴͽ̣¡

ÓÃjs´úÂëÀ´ ¿ØÖÆ divµÄ¶¯×÷´Ó¶øÄÜʵÏÖ

js¿ØÖÆdivÏÔʾ/Òþ²ØÁË

VS2008×Ô´ø·â×°Á ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ