請問如何在更新數(shù)據(jù)庫的語句中調(diào)用 函數(shù)阿?內(nèi)容如下:------r.asp--------------------------------<%dim ifunction gen_key(digits)dim rndnum,numRandomizeDo while Len(rndnum)<digitsnum = Cstr(Chr((57-48)*rnd+48))rndnum = rndnum & numLoopgen_key = rndnumEnd function%>------------------------------------------<!--#include file="conn.asp" --><!--#include file="r.asp" --><%dim actionaction=request.QueryString("action")'//保存提交信息if request.QueryString("action")="pwd" thenset rs=server.CreateObject("adodb.recordset")rs.Open "select * from vote order by m_id asc",conn,1,3--->>>>>后面的1和3 表示什么意思???dim pwdpwd=gen_key(6)conn.execute "update vote set m_pwd=pwd" ----->>>>>>>>>這里該怎么寫呢?rs.closeset rs=nothingresponse.Write "<script language=javascript>alert('“員工密碼隨機生成”成功!');window.location.href('passwdzero.asp');</script>" end if%>----------------------------------------------------------在用sql語句更新的時候,后面不能調(diào)用函數(shù),不過你可以把所調(diào)用的函數(shù)嵌套到更新語句中來嘛.
具體該怎么寫那? 如何嵌套啊,什么格式呀?
搖曳的薔薇
2023-01-03 21:16:38