Need help with error messgage...

I am trying to match a string on the server side of an ASP page. My code is this:

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!-- #include file = "connection.asp" -->
<!-- #include file = "replace.asp" -->

<%
var r_user;
var r_pass;

r_user = Request.querystring("xyz");
r_pass = Request.querystring("abc");

r_user = replaceAwithBinC("'","'",r_user + '');
r_pass = replaceAwithBinC("'","'",r_pass + '');

r_user = replaceAwithBinC('"',""",r_user + '');
r_pass = replaceAwithBinC('"',""",r_pass + '');

var quer = "SELECT access_code FROM resourceadmin WHERE (user_name = '" + r_user + "') AND (user_pass = '" + r_pass + "')";
var rs = Server.CreateObject("ADODB.RecordSet");
rs.Open(quer,con);	

var access = rs("access_code");
Response.Write(access);

if(access.indexOf("wc")<0) {
	Response.Write("Yes");
}
else{
	Response.Write("No");
}

rs.Close();
rs = null;

con.Close();
con = null;
%>

Code (markup):

This gets a Username and Password from a URL link, gets the "access_code" from the Access database for that subscriber and then I am trying to match the access code for the letters "wc".

It works fine until it tries to match the string "wc" to the access code. The variable "access" properly appears as 999, so the match should return "No".

However, I get an "Object doesn't support this property or method" error for the line that has the if(access.indexOf("wc")<0) statement on it. I have tried using InStr(), but that doesn't work either.

Please help! I don't know why I am getting this error. Thanks.

 

I am guessing that access.indexOf("wc") is being considered a "string" and therefore, a string can not be < 0. Have you tried INT(access.indexOf("wc")) or CInt(access.indexOf("wc")) or CDbl(access.indexOf("wc")) to see if the error message goes away? I am not familiar with the indexOf property so this is just a guess on my part.

 

I just tired all of your suggestions and none made a difference, but it did inspire me to declare the variable as a string like this:

var access = new String(rs("access_code"));

Code (markup):

which works perfectly...THANKS!