Re: Does webcatalog recognise NULL values?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18440
interpreted = N
texte = >Please help. I'm currently using Webcatalog NT Version 2.1. >I need to use the [showif] command to show some code, based on the >argument of whether it has a value or not. > >Now this is not as straight forward as it sounds, because the cell can >potentially contain data in the format of text or number. > >I've tried using all sorts of commands, but doesn't seem to work because >some cells have numbers in and others have text in. > >What I need to do is to find out if webcatalog can test whether or not >the cell has a NULL value.[SHOWIF [fieldname]!]Text to display if the field is not empty[/SHOW][SHOWIF [variablename]![raw][variablename][/raw]]Text to display if the variable is not defined[/SHOW] ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Art director S-211 37 Malmoe Fax +46 40 97 99 77 Ljusa Ideer AB Sweden http://www.ljusaideer.se Associated Messages, from the most recent to the oldest:

    
  1. Re: Does webcatalog recognise NULL values? (Dave MacLeay 1998)
  2. Re: Does webcatalog recognise NULL values? (Christer Olsson 1998)
  3. Does webcatalog recognise NULL values? (Richard Zammit 1998)
>Please help. I'm currently using Webcatalog NT Version 2.1. >I need to use the [showif] command to show some code, based on the >argument of whether it has a value or not. > >Now this is not as straight forward as it sounds, because the cell can >potentially contain data in the format of text or number. > >I've tried using all sorts of commands, but doesn't seem to work because >some cells have numbers in and others have text in. > >What I need to do is to find out if webcatalog can test whether or not >the cell has a NULL value.[SHOWIF [fieldname]!]Text to display if the field is not empty[/SHOW][SHOWIF [variablename]![raw][variablename][/raw]]Text to display if the variable is not defined[/SHOW] ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Art director S-211 37 Malmoe Fax +46 40 97 99 77 Ljusa Ideer AB Sweden http://www.ljusaideer.se Christer Olsson

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:

WCS Newbie question (1997) [WebDNA] TCPconnect and Bitcoin rate (2019) Limit to Field Length in DB (1998) autocommit problem (1998) Passing Variables.. yikes, I'm dumb (2000) [createfolder] & [deletefolder] (1997) Summing results of a nested search (2006) Claris HomePage messes up the code (1997) Webmerchant -> MacAuthorize ... please retry ? (1997) Multiple shipping databases (1997) Sitebuilder (2004) Filemaker Pro and [convertchars] (2000) There's a bug in the math context ... (1997) [addlineitems] display (1997) WebCat2: Items xx to xx shown, etc. (1997) [WebDNA] unique words (2009) Changing Date Format in Field (1999) Electronic Delivery (1997) For those of you not on the WebCatalog Beta... (1997) WebDelivery downloads alias, not original ? (1997)