Detecting NULL value in returned SQL

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 26861
interpreted = N
texte = I searched the archives for this one, but couldn't find an answer...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....example..here are a bunch of consecutive refreshes to a page where I display field01, field02, and field03, where field03 is NULL: 1, first,1, first, OST=165.230.156.146&HTTP_USER_AGENT=Mozilla/4.0%(ŁE1, first, br> [FoundItems] [field01], [fI´02], [hideif(ŁE1, first, ext/html Content-Length: 190 etc....any ideas?=============================================== Howard Wolosky Webcatalog Consultant+The Pubb - The best solution for your messageboard needs. Written in 100% Webcat. (www.thepubb.com) ===============================================------------------------------------------------------------- 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)
I searched the archives for this one, but couldn't find an answer...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....example..here are a bunch of consecutive refreshes to a page where I display field01, field02, and field03, where field03 is NULL: 1, first,1, first, OST=165.230.156.146&HTTP_USER_AGENT=Mozilla/4.0%(ŁE1, first, br> [founditems] [field01], [fI´02], [hideif(ŁE1, first, ext/html Content-Length: 190 etc....any ideas?=============================================== Howard Wolosky Webcatalog Consultant+The Pubb - The best solution for your messageboard needs. Written in 100% Webcat. (www.thepubb.com) ===============================================------------------------------------------------------------- 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 Howard Wolosky

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:

[purchase] (1999) A Global Variable (1997) SMSI FTP (2002) AppleScript question (1997) protect tag on NT IIS (1997) Bug Report, maybe (1997) Export database record - append to other database (2005) Almost a there but..bye bye NetCloak (1997) Setting up WebCatalog with Retail Pro data (1996) RAM variables (1997) Best way to download a db (2003) Reminder... (2003) linetiems in thankyou.tpl (1997) Bug Report, maybe (1997) WebMerchant (2000) Extended [ConvertChars] (1997) What am I missing (1997) _ in front of field name (1998) [SHOWIF AND/OR] (1997) Nesting WebDNA in JavaScript (2003)