why does this comparison fail?

[bookouri]

<%target = rsnamelist(&quot;ID&quot %>

<% do while rsnamelist(&quot;id&quot= target %>

do some stuff

<% RSNameList.MoveNext %>
<% target = rsnamelist(&quot;id&quot %>
<% loop %>

my loop fails at the <% do while ..... %> with an error:
Type mismatch
/asp/reports/test.asp, line 100

Its my understanding that all variables are the same type in vb scripting? What am I doing wrong?


thanks

 

[zzfive03]

Varables are not of the same type. You just dont have to define them. They will be converted to the type once you store data in them.

You may need to cast the varable before you compare it. I have the problme sometimes where I have a varable and it has a number, and I am comparing it to another numeric number, unless I cast it as an INT, it gives me the same error.

Example:

Dim myNum
myNum = Request.Form(&quot;userinput&quot

If (int(myNum) = 8) Then ...

End If

Hope that helps.

Mark A horse walks into the bar, and the bartender says &quot;Why the long face&quot;?

 

[bookouri]

if i try to change any of the variable types I get errors because vb script only recognizes the VARIANT type.

 

[zzfive03]

Rather than trying to compare it against the fucntion. Try comparing 2 varables. Like so:

<%target = rsnamelist(&quot;ID&quot %>
<%newtarget = rsnamelist(&quot;ID&quot %>


<% do while newtarget= target %>

do some stuff

<% RSNameList.MoveNext %>
<% newtarget = rsnamelist(&quot;id&quot %>
<% loop %>

 

[bookouri]

I tried using the variables rather than the function but I still get the same data mismatch error.

It cant be this difficult. Ive always had good luck using asp/vb for projects, and this is one of the simplest things Ive tried to do and I just cant seem to make it work.

thanks again for the replies