Re: showif field is number

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15662
interpreted = N
texte = Kenneth Grome wrote: > > >Is their a quick way to do [showif [field] is a number] ? > > > >Will this work? [showif [math][field]+1[/math]!] In other words, if the > >field is non-numeric, the math context will return a blank. > > I think something like this will work, but I don't remember what's > returned, whether it's blank or zero or some unpredictable number. > You'll probably have to play around with this technique to see what > you get ... :)It turns out that WC will return a value for any field *starting* with a number. It will return the first number it sees, without performing whatever equation you've set up. if [sku]=111abc222def then [math][sku]+1[/math] will return 111It only increments if it is a pure number.I ended up doing a comparison of the results to determine if it incremented.Pat Associated Messages, from the most recent to the oldest:

    
  1. Re: showif field is number (Kenneth Grome 1997)
  2. Re: showif field is number (Pat McCormick 1997)
  3. showif field is number (Pat McCormick 1997)
Kenneth Grome wrote: > > >Is their a quick way to do [showif [field] is a number] ? > > > >Will this work? [showif [math][field]+1[/math]!] In other words, if the > >field is non-numeric, the math context will return a blank. > > I think something like this will work, but I don't remember what's > returned, whether it's blank or zero or some unpredictable number. > You'll probably have to play around with this technique to see what > you get ... :)It turns out that WC will return a value for any field *starting* with a number. It will return the first number it sees, without performing whatever equation you've set up. if [sku]=111abc222def then [math][sku]+1[/math] will return 111It only increments if it is a pure number.I ended up doing a comparison of the results to determine if it incremented.Pat Pat McCormick

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:

Mapping .tmpl extension on NT (1998) File not found error message (1998) emailer settings and control questions (1997) default value from Lookup (was Grant, please help me) (1997) WebCat Admin access w/ClearlyHome p.i. (1997) [ShowNext] (1997) [WebDNA] Hmmm ... (2008) [ModDate] & [ModTime] ? (1997) Encrypt Users.db problem (1998) Setting up WebCatalog with Retail Pro data (1996) Single Link browsing (1997) Post arguments problem mac? (1997) Create Folder Question... (2000) Encryption of E-mail (1998) No luck with taxes (1997) Dr.Watson Error (1999) [Fwd: F3 database munching] (1997) [OT] Display Glitch (2004) Strange intermittent WebDNA problems (2008) help (2001)