p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_codeclinic thread: Problems with Null


Message #1 by "Rick Brose" <brose@u...> on Thu, 31 May 2001 14:24:11
Modify the field in the database so that it contains "" rather than 
null by
default.  Then you will only have one thing to test for.

-----Original Message-----
From: Rick Brose [mailto:brose@u...]
Sent: 31 May 2001 15:24
To: Code Clinic
Subject: [proasp_codeclinic] Problems with Null


I have a knowledge base that allows users to contribute their own 
ideas.
On the contribute page it has an optional field for Email address. In 
the
knowledge base when it lists someone's contribution that does not have 
an
email address present in the database I want it to output "No Email 
Given"
in the email spot. It works fine if I enter the person from inside the
database but if the person submits it from the web it doesn't recognize 

the email field as being null...

  If arrEmail(0, numBoxes) <> "" Or Not IsNull(arrEmail(0, numBoxes)) 
then
	strEmailMes =3D arrEmail(0, numBoxes)
  Else
	strEmailMes =3D "No Email Given"
  End If

Above is the code I use to check if the entry is not Null...Is there
something I am missing? If I switched to checking for it to be Null and 

not Null would that somehow change the outcome? Any suggestions?
________________________________________________________________________

Scottish Enterprise Network
http://www.scottish-enterprise.com

  Return to Index