Comparing Numbers doesn't seem to work

[tempoman]

Can someone suggest any solution to this problem I am facing.

I have two values that I would like to compare to see if they are the same. However when I use it in a "if" statement it does not equaluate to the same value, however printing it out on the screen displays it as being the same value. Below my code.

Note: The values are numeric values
------------------------------------
UserID = Request.Form("UserList&quot

AuthornameQry = "PublicationRelation.AuthorID" &_
"FROM PublicationRelation "

Set ast = Server.CreateObject("ADODB.Recordset&quot
ast.Open AuthorNameQry, strProvider

authorid = ast.Fields("AuthorID&quot.Value

if "&authorid&" = "&UserID&" then
Response.Write " Same Author "
else
Response.Write " Different Author "
end if


Any suggestions will be grateful

Thanx

 

[palbano]

My VB is very poor... but you might try changing:

> if "&authorid&" = "&UserID&" then

to:

if authorid = UserID then


Hope this helps
-pete