Re: how to check for null in string

2009-02-17 Thread Johan De Meersman
In SQL, the correct syntax is IS NULL or IS NOT NULL. Random programming languages more often than not have no decent support for NULL content, although your DB library might have an isnull() function or something similar. Once you've exported a field into a regular variable, however, most often

Re: how to check for null in string

2009-02-17 Thread Joerg Bruehe
Hi ! Johan De Meersman wrote: In SQL, the correct syntax is IS NULL or IS NOT NULL. Random programming languages more often than not have no decent support for NULL content, although your DB library might have an isnull() function or something similar. Once you've exported a field into a

Re: how to check for null in string

2009-02-17 Thread PJ
Johan De Meersman wrote: In SQL, the correct syntax is IS NULL or IS NOT NULL. Random programming languages more often than not have no decent support for NULL content, although your DB library might have an isnull() function or something similar. Once you've exported a field into a regular

how to check for null in string

2009-02-16 Thread PJ
I know this is not working, but how can I check for NULL; or how can I configure my field sub_title so I can check if $booksub_title contains anything or is empty. This problem as been breaking my back...don't know what to put in as a default to be able to check against string input (VARCHAR) or