Comparing Numeric Values

I am very frustrated because I still cannot get to work this. I tried doing what Ijamal suggested. I got the following error message:

Item cannot be found in the collection corresponding to the requested name or ordinal. I will bold the line that got this error message. AreaID definitely exists in the City database.

   'Build the sql query used to fill the select element

    sql = "select IsNull(AreaID, 0) from City"

    sql = sql & " where City= '" & hidCity & "'"

    sql = sql & " and State= '" & hidState & "'"

       'Create a recordset

      set rsCity = Server.CreateObject("ADODB.Recordset")

      rsCity.Open sql, connectionString, adOpenDynamic, adLockOptimistic

    'Initalize Error

    Error = False

  If rsCity.EOF then  

    'Area doesn't exist in state

    Response.write(hidCity & " in " & hidState & " does not exist in database")

Else

    'Area does exist in DB

    'Check to see if the database already has this area

    If CLng(Area) = CLng(rsCity("AreaID")) then (where the error is)

    Error = True

    %>

<%

'Move to the next recordset

rsCity.MoveNext

If Error = False then 

Gullanian,

Thank you for the code! It almost worked. But there is still something wrong. I think that it has something to do with the line of code: If Clng(Area) = rsCity("AreaID") then. It is frustrating because it won't let me use CLng(rsCity("AreaID")).

I found out it would update the AreaID when I had the following code: 
If rsCity.EOF then
'Area doesn't exist in state
Response.write(hidCity & " in " & hidState & " does not exist in database") 
Else
'Move to the next recordset
rsCity.MoveFirst
rsCity("AreaID") = Area
rsCity.update
End If

But this is not acceptable for this case. I want the AreaID to be only updated if the AreaID for a certain city is null. Does anyone have any idea how I might be able to make sure that both Area (from the form) and AreaID (from the database) are the same.