数据库问题,急急急急急,在线等
源程序
<%@ Language=JavaScript %>
<%
var strChengQuMark,strFirstChanelMark,strChengQuId,strUrl;
var strSql;
var objRs = Server.CreateObject("Adodb.Recordset");
strFirstChanelMark = Request.QueryString("FirstChanelMark");
strChengQuMark = Request.QueryString("ChengQuMark");
strChengQuId = Request.QueryString("ChengQuId");
strSql = "select * from sysobjects Where name = '" + strChengQuMark + "_" + strFirstChanelMark + "_Information'";
objRs.Open(strSql,objConn,adOpenStatic,adLockReadOnly,1);
if (!objRs.EOF) {
strURL = strURL + ".asp?FirstChanelMark=" + strFirstChanelMark + "&ChengQuMark=" + strChengQuMark;
}
else {
strURL = "ErrorView.asp?strNews=此栏目暂时不需维护!";
}
Response.Redirect (strURL);
%>
如果我定义了strChengQuId=8,那么strURL=DCEssayList,不为8时,strURL=EssayList,应该怎么改,请高手指教,小弟先谢了,急啊