Question

ORA-00920: 无效的关系运算符

ORA-00920: 无效的关系运算符

说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.OracleClient.OracleException: ORA-00920: 无效的关系运算符

源错误:

行 34: conn.Open();
行 35: OracleDataReader dr;
行 36: dr = com.ExecuteReader();
行 37: dr.Read();
行 38: while (dr.Read())

源文件: d:\Backup\我的文档\Visual Studio 2005\WebSites\WebSite2\e1.aspx.cs 行: 36
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Drawing;
using System.ComponentModel;
using System.Web.SessionState;
using System.Collections.Generic;
using System.Text;
using System.Data.OracleClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(Object sender, EventArgs e)
{
Response.Write("<center><b>身份验证登陆</b></center>");
}
public void Button1_Click(Object sender, EventArgs e)
{
string strName = TextBox2.Text.Trim();
string strPass = TextBox3.Text.Trim();
//server=数据库Sid的名字
OracleConnection conn = new OracleConnection("server=station;user id=system;password=sq888888;data source=station");
string sql = "select LOG NAME,PASSWORD from SCOTT.LIB where LOG NAME='" + strName + "' and PASSWORD='" + strPass + "'";
OracleDataAdapter da = new OracleDataAdapter("select * from SCOTT.LIB", conn);
OracleCommand com = new OracleCommand(sql, conn);
conn.Open();
OracleDataReader dr;
dr = com.ExecuteReader();
dr.Read();
while (dr.Read())
{
string strComPass = (string)dr["PASSWORD"];
if (strPass == strComPass)
{
Response.Redirect("e2.aspx");
}

else
{
Response.Write("用户名或密码错误,请重新输入");
}

}
dr.Close();
conn.Close();
}

}
请高手帮忙。

Answer 1

怀疑是空格的问题
LOG NAME改成LOG_NAME试试。