霸花店完整版在线观看:ASP初学!急急!!!!1

来源:百度文库 编辑:查人人中国名人网 时间:2024/04/29 18:41:41
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/conn.asp" -->
<%
Dim rs1
Dim rs1_numRows
dim id1
Set rs1 = Server.CreateObject("ADODB.Recordset")
id1=request.QueryString("user")
rs1.ActiveConnection = MM_conn_STRING
rs1.Source = "SELECT * FROM classl WHERE user="&id1&""
rs1.CursorType = 0
rs1.CursorLocation = 2
rs1.LockType =1
rs1.Open()

rs1_numRows = 0
%>
<%

response.write ("密码:" & (rs1.Fields.Item("pwd").Value))
response.write ("用户名:" & (rs1.Fields.Item("user").Value))
%>
<%
rs1.Close()
Set rs1 = Nothing
%>请问哪里出错了?????????????????????????????急死我了!
我改了,还是该页无法显示

rs1.Source = "SELECT * FROM classl WHERE user='"&id1&"'"

字符串要用单引号

rs1.Source = "SELECT * FROM classl WHERE user="&id1&"" 该为
rs1.Source = "SELECT * FROM classl WHERE user='"&id1&"'"

rs1.Source = "SELECT * FROM classl WHERE user="&id1

同意一楼