NULL value question



I'm coding my first web site using a mysql
database and DBI.

I can fetch records from the database
with no problem, but I'm having trouble
testing NULL values. If I load the value
of a date field into a variable ($dateadded),
how should the IF condition be written?

if ( $dateadded = NULL ) {

print "Date added is NULL";

}

I found some information that talked
about NULLs being undef, but I'm
not sure how to use that information.
.



Relevant Pages

  • Re: NULL value question
    ... I can fetch records from the database ... with no problem, but I'm having trouble ... If I load the value ... There are some edge cases you need to be wary of -- a DBI call may ...
    (comp.lang.perl.misc)
  • Re: Click Function Problem - Code Help Required
    ... 60 odd queries in this database. ... what I need replaced with a valid function. ... Data member not found ... >I'm having trouble getting my message across on this one. ...
    (microsoft.public.access.forms)
  • Re: Out of Memory (Error 7) when adding a VBA function
    ... Thanks for the rapid response and comprehensive troubleshooting method. ... corrupted file through your methodology at first chance and will report back. ... Compact the database to get rid of this junk: ... trouble. ...
    (microsoft.public.access.formscoding)
  • Re: Looking for advice on how to get started
    ... least trouble) way is to put this into a database. ... be able to ruin the format of your data. ... Another matter is security. ...
    (comp.programming)
  • Re: Help with default fields...
    ... Trouble Call database list that is designed so our operation manager can add ... Trouble Call database to reference that list. ... since it is the only one that will let me edit the entry (In other words, ...
    (microsoft.public.sharepoint.windowsservices)