asp代码在<%@ Language=JavaScript %>页面如何写

[xiejunhua]

user=Session("user_name")
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select cid from table1 where pay='Y' and user='"& user &"'"
rs.Open sql,Cnndb,3,1
while not rs.eof
CString=CString & ","&trim(rsn("cid"))
rsn.movenext
wend
rs.close
set rs=nothing
Session("Cstr")=CString
改在
<%@ Language=JavaScript %>页面
var user=Session("user_name");
var rs=Server.CreateObject ("adodb.recordset");
var sql="select * from table1 where user='"+user+"'";

之后循环取值组成字符串如何写呀?

[xiejunhua]

有人帮忙吗？

• 打赏
• 举报

回复 赞

[fason]

var CString = "";
while(!rs.eof){
CString+= (","+String(rsn("cid")));
rsn.movenext;
}
rs.Close();
rs=null
Session("Cstr")=CString;

• 打赏
• 举报

回复 赞

[wanghr100]

Try..

<%@ Language=JavaScript %>
<%
var user=Session("user_name");
var rs = Server.CreateObject("ADODB.Recordset");
var sql="select cid from table1 where pay='Y' and user='"+ user +"'";
rs.Open(sql,Cnndb,3,1)
while(!rs.eof){
CString = CString + "," + rs("cid").trim()
rs.MoveNext();
}
rs.close();
delete rs;
Session("Cstr")=CString;

//JavaScript没有trim方法.自己定义.
//调用str.trim() 去掉左右的空格.
String.prototype.trim = function()
{
return this.replace(/(^\s*)|(\s*$)/g, "");
}
%>

• 打赏
• 举报

回复 赞

[wanghr100]

<%
var CString = "";
var user=Session("user_name");
var rs = Server.CreateObject("ADODB.Recordset");
var sql="select cid from table1 where pay='Y' and user='"+ user +"'";
rs.Open(sql,Cnndb,3,1)
while(!rs.eof){
CString += "," + String(rs("cid")).trim();
rs.MoveNext();
}
rs.close();
delete rs;
Session("Cstr")=CString;

//JavaScript没有trim方法.自己定义.
//调用str.trim() 去掉左右的空格.
String.prototype.trim = function()
{
return this.replace(/(^\s*)|(\s*$)/g, "");
}
%>

• 打赏
• 举报

回复 赞

[xiejunhua]

谢谢！

• 打赏
• 举报

回复 赞