Do not use on any
shared computer
August 30, 2008 04:21am pdt
 
[x]
Attachment Details

Comparing the value of a record against what is submitted Error error '80020009'

Hello everyone,
I am getting a weird error
error '80020009'
I have a form that employees fill out. It's part of their profile with address, city, state, zip etc... When a user goes to the profile and doesn't change anything except their password I get the above error message. Basically I have the form submit and the values are passed via Querystring to a page that is emailed. The emailed page runs some code that does a compare check to see if the value has changed or not and if it has then it updates the record and then posts a message stating that the record has changed. Can someone take a look at the code and let me know where I am going wrong?

Thanks,
Jester

1:
2:
3:
4:
5:
6:
Dim vhome_address1
if objRs("Home_Address") <>  sNewAddress1 OR isnull(objRs("Home_Address").value) then
  vhome_address1 = "Address1 has been changed<br/><blockquote>old value: "& objRs("Home_Address") &"<BR>new value: "& sNewAddress1 &"</blockquote>"
  objRs("Home_Address") = sNewAddress1
  bNoUpdates = false
end if
Start your free trial to view this solution
Question Stats
Zone: Web Development
Question Asked By: awinstead
Question Asked On: 06.20.2008
Participating Experts: 1
Points: 500
Views: 0
Translate:
Loading Advertisement...
 
[+][-]Expert Comment by hielo

Rank: Sage

Expert Comment by hielo:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Author Comment by awinstead
Author Comment by awinstead:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by hielo

Rank: Sage

Expert Comment by hielo:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
20080723-EE-VQP-34 / EE_QW_2_20070628