Did this question ever get a resolution.

I checked the web and removed all the chr 13 and nulls from my data, and I still get the same error as this guy did 3 years ago.

http://p2p.wrox.com/archive/asp_ecom...2000-09/29.asp

__________________________________________________ ________

Folks,



I have reached page 187 of the book with the code to create the detail.asp

page. When testing the page I get the error



EstoreCommerce error '800a005e'



Invalid use of Null



/NoNameWebStore_Local/en/detail.asp, line 44





Line 44 of the page corresponds to:



mfrname = Product.MfrName





I have double checked the code in both detail.asp and the Product class

module of the WroxCommerce component but couldn't find any spelling

mistake.



I am quite a beginner with ASP and I don't exactly know what causes this

error. Does anyone have a suggestion on what may be the cause and how I

can resolve this problem? Thank you.



* Marco

Message #2 by "Ben Lew" <formula1@b...> on Tue, 19 Sep 2000 00:07:18 -0400



Null is a somewhat tricky subject b/c it is technically not "0" nor is it

"nothing" but rather it is "unknown" (for example, if you have two database

fields that are "null" and you compare one to the other, such as "if

field1=field2 then..." and both were null, this would result in "false"

because null is not equal to null since both are unknown values. Chances

are somewhere in your code you are referencing a null value incorrectly.



Ben



-----Original Message-----

From: Marco Garibaldi [mailto:[email protected]]

Sent: Monday, September 18, 2000 12:07 PM

To: ASP ECommerce

Subject: [asp_ecommerce] Error: Invalid use of Null





Folks,



I have reached page 187 of the book with the code to create the detail.asp

page. When testing the page I get the error



EstoreCommerce error '800a005e'



Invalid use of Null



/NoNameWebStore_Local/en/detail.asp, line 44





Line 44 of the page corresponds to:



mfrname = Product.MfrName





I have double checked the code in both detail.asp and the Product class

module of the WroxCommerce component but couldn't find any spelling

mistake.



I am quite a beginner with ASP and I don't exactly know what causes this

error. Does anyone have a suggestion on what may be the cause and how I

can resolve this problem? Thank you.



* Marco



---

You are currently subscribed to asp_ecommerce as: [email protected]

To unsubscribe send a blank email to $subst('Email.Unsub')

Hi there,

Can you paste some of the relevant code for this example so we can take a look at it? It's hard to guess what the problem is without seeing the actual code.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Imar, Thanks for your "help". I took another look at the problem and took the error message at face value. It was null values in the mfg table for the e-mail contact.

I filled them in with a default value and the application worked great.

I'm new to the VB-Object world. I've been using NT from the alpha 3.1 release and was teaching SQL Server as far back as on OS2 (pre-NT).

I can't count the number of times I've given the advice that would have solved my problem right away.

Thanks,

LT

Oh well, I am sure that happens to all of us. At least it does happen to me frequently.... ;)

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.