易截截图软件、单文件、免安装、纯绿色、仅160KB

好久没写ASP程序,都傻了。简单问题求解




<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>


<%'response.ContentType ="application/vnd.ms-excel"%>

<%
Set rs=server.CreateObject("adodb.recordset")
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("data/zsb.mdb")

dim Stryear,semester,sql,Strsort
Stryear=trim(request("Stryear"))
if not IsNumeric(Stryear) or isEmpty(Stryear) then
  Response.Write(" <script type='text/javascript'>alert('输入的不是数字'); window.history.back(-1); </script>")
  end if
semester=trim(request("semester"))
Strsort=trim(request("Strsort"))
sql="SELECT DISTINCT cj.XH, xsda.XM, cj.KC, cj.CJ, cj.KSDATE, bj.BJ, cj.xq, cj.kslxdm from bj INNER JOIN (xsda INNER JOIN cj ON xsda.XH = cj.XH) ON bj.BJDM = xsda.BJDM WHERE (((cj.xq)='"&Stryear&"年"&semester&"') AND ((cj.kslxdm)='"&Strsort&"') AND ((bj.BJDM) Like 'CZ*')) ORDER BY cj.XH, cj.KC;"
response.Write(sql)

rs.Open sql, Conn, 3,1
response.Write(rs.recordcount)
%>

<table width="586" border="0" align="cente


相关问答:

在asp.net里面脚本出错 - .NET技术 / ASP.NET

function CheckOpwd(){//验证用户名
var pwd=document.all.txtOpwd;

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

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

新手请教一个asp的类型转换问题! - Web 开发 / ASP

本人不会asp,报错了,请大家帮忙看看。
代码如下:
<%
dim keyword_Name,keyword_YJ,keyword_RQ
if rs("QS_PASS_1_name")<>"0,0" then
keyword_Name=split(rs("QS_ ......

asp数据库问题 - Web 开发 / ASP

各位大虾,我做了一个ASP得通讯录,但是除了查询功能好像其他都有问题,其中添加功能如下,能指导一下我哪里出错了吗?
<html>
<head>
<title>无标题文档</title>
</head>
<b ......

ASP链接SQL的简单登陆界面 - .NET技术 / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号