Re: NULL value question



In article <MPG.211951b1631c501998968c@xxxxxxxxxxxxxxxxxxxx>,
jim@xxxxxxxxxxxxx says...
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 (!defined $dateadded) works perfectly!

Thanks to all who responded!


.



Relevant Pages

  • Re: How to use SQL to load supertype and subtype table data
    ... > I'm loading data into a database but having trouble (probably ... > then using that primary key as the Foreign Key to load data into my ... > very different local database ... > to use SQL and not a native API ...
    (comp.databases)
  • 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)