Hi,



I am receiving an  error '80020009' Exception occurred. When selecting a 

particular record from the database based on a querystring, a 

master/details type of situation. It shows that my recordset is empty, but 

only in netscape navigator 4.7. It works fine in internet explorer and 

netscape 6. Any ideas what could be causing this? I though it wouldnt make 

any difference what browser you have since it is processed on the server. 

Could it be they way netscape handles the query string? I printed out the 

sql statement and it looked identical to the ones in i.e. and netscape 6.



Thanks for you help.

Nick 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Nicholas Elsberry" <elsberrn@c...>

Subject: [asp_databases] Execption Occurred - Only in netscape 4.7





: I am receiving an  error '80020009' Exception occurred. When selecting a

: particular record from the database based on a querystring, a

: master/details type of situation. It shows that my recordset is empty, but

: only in netscape navigator 4.7. It works fine in internet explorer and

: netscape 6. Any ideas what could be causing this? I though it wouldnt make

: any difference what browser you have since it is processed on the server.

: Could it be they way netscape handles the query string? I printed out the

: sql statement and it looked identical to the ones in i.e. and netscape 6.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Certain characters are not allowed in querystrings. Instead you need to use

"Encoded" values. This is defined in the HTTP RFC (the HTTP specification).



When you request a URL that contains illegal characters, Internet Explorer

transparently encodes these values for you (eg replacing spaces with %20 and

+), before sending the request to the server.



Netscape doesn't do this.



To get around this problem, you should Server.URLEncode() any values that

you want to pass in the querystring.



Cheers

Ken

Ken-



Thanks for your help. I was sure that I had used Server.URLEncode() but it 

looks like I had missed one of the values i pass through the query string.



Thanks much.

-Nick