ORA-00911: invalid character

cpajoe2001 · May 16th, 2006, 10:05 AM

I'm getting this error with my code below. However the error is only there when I have my WHERE statement. Any help would be appreciated.

Code:

<% @Language = JScript %>
<html>
<head>
<%
  var db=Server.CreateObject("ADODB.Connection"); 
  db.Open("Provider=OraOLEDB.Oracle;Data Source=IAS4;User Id=client;Password=password;"); 

  var query1 = "SELECT AREA FROM ADDN WHERE PARID = 0031635500;"; 
  Cust = db.Execute(query1);        

%>
</head>

<body>

<%=Cust("AREA")%>

</body>

</html>

Code:

<% @Language = JScript %>
<html>
<head>
<%
  var db=Server.CreateObject("ADODB.Connection"); 
  db.Open("Provider=OraOLEDB.Oracle;Data Source=IAS4;User Id=client;Password=password;"); 

  var query1 = "SELECT AREA FROM ADDN WHERE PARID = '0031635500';"; 
  Cust = db.Execute(query1);        

%>
</head>

<body>

<%=Cust("AREA")%>

</body>

</html>

Code:

<% @Language = JScript %>
<html>
<head>
<%
  var db=Server.CreateObject("ADODB.Connection"); 
  db.Open("Provider=OraOLEDB.Oracle;Data Source=IAS4;User Id=client;Password=password;"); 

  var query1 = "SELECT AREA FROM ADDN WHERE PARID = ' + 0031635500 + ';"; 
  Cust = db.Execute(query1);        

%>
</head>

<body>

<%=Cust("AREA")%>

</body>

</html>

Code:

<% @Language = JScript %>
<html>
<head>
<%
  var db=Server.CreateObject("ADODB.Connection"); 
  db.Open("Provider=OraOLEDB.Oracle;Data Source=IAS4;User Id=client;Password=password;"); 

  var numtest = 0031635500;

  var query1 = "SELECT AREA FROM ADDN WHERE PARID = ' + numtest + ';"; 
  Cust = db.Execute(query1);        

%>
</head>

<body>

<%=Cust("AREA")%>

</body>

</html>

Those are all variations that I had tried and the only one I can do and not get the error is

Code:

<% @Language = JScript %>
<html>
<head>
<%
  var db=Server.CreateObject("ADODB.Connection"); 
  db.Open("Provider=OraOLEDB.Oracle;Data Source=IAS4;User Id=client;Password=password;"); 

  var query1 = "SELECT AREA FROM ADDN;"; 
  Cust = db.Execute(query1);        

%>
</head>

<body>

<%=Cust("AREA")%>

</body>

</html>

cstooch · July 22nd, 2006, 04:10 PM

I noticed in one case you encase your PARID value in single quotes (i.e. a string/varchar datatype) and in the first instance, you have it as an integer (no single quotes).

Could that possibly be the cause of your problem? (i.e. if PARID is an integer, don't encase it in single quotes, if PARID is supposed to be a varchar/string then encase it in single quotes).

Also, beyond that, maybe I'm just not familiar with what you're doing, but within the single quotes you have + 0031635500 + , as though you are inserting a variable in there. What was the purpose of the single quotes and plus symbols?

Also, further down, you have ' + numtest + '

numtest is a variable in your C# code. What you really want here I believe is:

var query1 = "SELECT AREA FROM ADDN WHERE PARID = " + numtest + ";";

So correct me if I'm wrong, but I think your code should look like this (assuming PARID is of an integer datatype):
[code]

<% @Language = JScript %>
<html>
<head>
<%
  var db=Server.CreateObject("ADODB.Connection");
  db.Open("Provider=OraOLEDB.Oracle;Data Source=IAS4;User Id=client;Password=password;");

  var query1 = "SELECT AREA FROM ADDN WHERE PARID = 0031635500;";
  Cust = db.Execute(query1);

%>
</head>

<body>

<%=Cust("AREA")%>

</body>

</html>

<% @Language = JScript %>
<html>
<head>
<%
  var db=Server.CreateObject("ADODB.Connection");
  db.Open("Provider=OraOLEDB.Oracle;Data Source=IAS4;User Id=client;Password=password;");

  var query1 = "SELECT AREA FROM ADDN WHERE PARID = 0031635500;";
  Cust = db.Execute(query1);

%>
</head>

<body>

<%=Cust("AREA")%>

</body>

</html>

<% @Language = JScript %>
<html>
<head>
<%
  var db=Server.CreateObject("ADODB.Connection");
  db.Open("Provider=OraOLEDB.Oracle;Data Source=IAS4;User Id=client;Password=password;");

  var query1 = "SELECT AREA FROM ADDN WHERE PARID = 0031635500;";
  Cust = db.Execute(query1);

%>
</head>

<body>

<%=Cust("AREA")%>

</body>

</html>

<% @Language = JScript %>
<html>
<head>
<%
  var db=Server.CreateObject("ADODB.Connection");
  db.Open("Provider=OraOLEDB.Oracle;Data Source=IAS4;User Id=client;Password=password;");

  var numtest = 0031635500;

  var query1 = "SELECT AREA FROM ADDN WHERE PARID = " + numtest + ";";
  Cust = db.Execute(query1);

%>
</head>

<body>

<%=Cust("AREA")%>

</body>

</html>

Those are all variations that I had tried and the only one I can do and not get the error is

<% @Language = JScript %>
<html>
<head>
<%
  var db=Server.CreateObject("ADODB.Connection");
  db.Open("Provider=OraOLEDB.Oracle;Data Source=IAS4;User Id=client;Password=password;");

  var query1 = "SELECT AREA FROM ADDN;";
  Cust = db.Execute(query1);

%>
</head>

<body>

<%=Cust("AREA")%>

</body>

</html>

[code]

ayyub123 · August 18th, 2008, 06:52 AM

Remove the semi-colon; It will work.

Mohammed Ayyub