Re: Detecting NULL value in returned SQL

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 26862
interpreted = N
texte = >How do I detect if a field is NULL from an SQL context? A standard >webcat database field can be checked like this [hideif >[field]=]....[/hideif]...but this doesn't work through SQL....I'm >getting random information from the system memory....Not sure if you mean a field whose name is null, or a field which has null data in it. All fields must be named, and for the case of null data, you probably have an older WebCatalog installed. Send me private email with your current version# for an update.Technical Support ********************************** Smith Micro, Internet Solutions Div | Formerly, Pacific Coast Software 16855 West Bernardo Drive | ------------------------- Suite 380 | eCommerce (WebCatalog) San Diego, CA 92127 | Software & Site Development 858.675.1106 | http://www.smithmicro.com 858.675.0372 (fax) **********************************------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: Detecting NULL value in returned SQL (WebDNA Support 2000)
  2. Detecting NULL value in returned SQL (Howard Wolosky 2000)
>How do I detect if a field is NULL from an SQL context? A standard >webcat database field can be checked like this [hideif >[field]=]....[/hideif]...but this doesn't work through SQL....I'm >getting random information from the system memory....Not sure if you mean a field whose name is null, or a field which has null data in it. All fields must be named, and for the case of null data, you probably have an older WebCatalog installed. Send me private email with your current version# for an update.Technical Support ********************************** Smith Micro, Internet Solutions Div | Formerly, Pacific Coast Software 16855 West Bernardo Drive | ------------------------- Suite 380 | eCommerce (WebCatalog) San Diego, CA 92127 | Software & Site Development 858.675.1106 | http://www.smithmicro.com 858.675.0372 (fax) **********************************------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to WebDNA Support

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Spawning Holdup? (2000) 2 HTTP Servers on one machine (2006) case sensitivity in lookups (1997) more info on [setlineitems] (1997) The beginning (1997) [searchString] (1997) MacAuthorize order data fields WAS:How To question... (1997) [WebDNA] Stupid question about CentOS v4 and WebDNA v6 (2008) Not really WebCat- (1997) WebCat editing, SiteGuard & SiteEdit (1997) [SQL] & ODBC on Mac (2000) Quickbooks Invoice / Payment Generation (2006) Setting up shop (1997) [WebDNA] WebDNA slow processing (2011) sort problems....bug or brain fart? (1997) [WebDNA] orderfile - encrypt test request (2011) RE: Ongoing group search problems ... (1997) Signal Raised (1997) Error Lob.db records error message not name (1997) Bug Report, maybe (1997)