UC知道网页制作中slect from的问题
来源：百度知道 编辑：UC知道 时间：2024/06/11 11:55:35
运行后出现FROM 子句语法错误。
/xg/result.asp, 第 23 行
<!--#include file = "conn.asp"-->
<%
dim username,userpassword,userpassword2,cjpassword,email,sql
username=request.Form("username")
userpassword=request.Form("userpwd")
userpassword2=request.Form("userpwd2")
cjpassword=request.Form("cjpassword")
email=request.Form("email")
If username = "" Or userpassword = "" Or userpassword2 = "" Or cjpassword = "" Or email = "" Then
response.write "<script language=JavaScript>" & chr(13) & "alert('请检查您填写的内容是否完整！');" & "history.back()" & "</script>"
Response.End
ElseIf Instr(Email, "@") = 0 Or Right(Email, 1) = "@" Or Left(Email, 1) = "@" Then
response.write "<script language=JavaScript>" & chr(13) & "alert(&
/xg/result.asp, 第 23 行
<!--#include file = "conn.asp"-->
<%
dim username,userpassword,userpassword2,cjpassword,email,sql
username=request.Form("username")
userpassword=request.Form("userpwd")
userpassword2=request.Form("userpwd2")
cjpassword=request.Form("cjpassword")
email=request.Form("email")
If username = "" Or userpassword = "" Or userpassword2 = "" Or cjpassword = "" Or email = "" Then
response.write "<script language=JavaScript>" & chr(13) & "alert('请检查您填写的内容是否完整！');" & "history.back()" & "</script>"
Response.End
ElseIf Instr(Email, "@") = 0 Or Right(Email, 1) = "@" Or Left(Email, 1) = "@" Then
response.write "<script language=JavaScript>" & chr(13) & "alert(&
set rs = Conn.Execute(sql)
换成这样的试试
set rs=Server.CreateObject("Adodb.RecordSet")
rs.open sql,conn,1,3
给 user 加上[]，user是sql的关键字，为了让sql知道user是一个表名，就要加上[]来区分，否则会报错。
sql = "select * from [user] where username='"&username&"'"