Re: An Isnumeric function of some kind

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37066
interpreted = N
texte = on 10/7/01 10:27 AM, Andrew Simpson at andrew.simpson@trendsbooks.com wrote:unless there is an easier way to do it with a query.select sum (CJAN, CFEB, CMAR etc) where id = 123 from statsdb but using webcat search context somehow???> I am looping through a found items creating field names in one table from > the manipulated rows of another. > > The Idea is to Add all the values from the columns in the stats table, > seperated by prefix eg V or C and add up each months worth of numbers > > EG... > > Search stats > //Contains VJAN, CJAN, VFEB, CFEB, VMAR as column headers with numbers in > //each row. > > found items > > search month db > //Contains months January February March April ...ETC > > [textshow=t]ShortMonth=[getchars start=1&end=3][MONTH][/getchars][/text] > //gives JAN FEB MAR etc > > > //need to check if C+JAN = 39 and not CJAN for example > [showif [interpret][c[shortmonth]][/interpret]!] > [math show=t]count=count+[interpret][c[shortmonth]][/interpret][/math] > [/showif] > > > //ISNUMERIC FUNCTION REQUIRED HERE PLEASE > [showif [interpret][V[shortmonth]][/interpret]![shortmonth]] > [math show=t]Views=Views+[interpret][c[shortmonth]][/interpret][/math] > [/showif] > > /search > /founditems > /search > > > ------------------------------------------------------------- > 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 > > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: An Isnumeric function of some kind (Andrew Simpson 2001)
  2. Re: An Isnumeric function of some kind (Rob Marquardt 2001)
  3. Re: An Isnumeric function of some kind (Brian Fries 2001)
  4. Re: An Isnumeric function of some kind (Andrew Simpson 2001)
  5. An Isnumeric function of some kind (Andrew Simpson 2001)
on 10/7/01 10:27 AM, Andrew Simpson at andrew.simpson@trendsbooks.com wrote:unless there is an easier way to do it with a query.select sum (CJAN, CFEB, CMAR etc) where id = 123 from statsdb but using webcat search context somehow???> I am looping through a found items creating field names in one table from > the manipulated rows of another. > > The Idea is to Add all the values from the columns in the stats table, > seperated by prefix eg V or C and add up each months worth of numbers > > EG... > > Search stats > //Contains VJAN, CJAN, VFEB, CFEB, VMAR as column headers with numbers in > //each row. > > found items > > search month db > //Contains months January February March April ...ETC > > [textshow=t]ShortMonth=[getchars start=1&end=3][MONTH][/getchars][/text] > //gives JAN FEB MAR etc > > > //need to check if C+JAN = 39 and not CJAN for example > [showif [interpret][c[shortmonth]][/interpret]!] > [math show=t]count=count+[interpret][c[shortmonth]][/interpret][/math] > [/showif] > > > //ISNUMERIC FUNCTION REQUIRED HERE PLEASE > [showif [interpret][V[shortmonth]][/interpret]![shortmonth]] > [math show=t]Views=Views+[interpret][c[shortmonth]][/interpret][/math] > [/showif] > > /search > /founditems > /search > > > ------------------------------------------------------------- > 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 > > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Andrew Simpson

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:

DNS Lookup 2 (2000) Time for a hard questions. (1997) Web Catalog vs. ICAT (1997) Preloading code? (2002) Re2: frames & carts (1997) Practice runs ? (1997) Separate SSL Server (1997) WebCatb15 Mac CGI -- [purchase] (1997) Template Cache problem (2000) PCS Emailer's role ? (1997) Leap Day Triggers (2000) Shell context. (2002) [WebDNA] [OT] Talk list (2009) auto-stripping of spaces (1997) [Sum] function? (1997) unable to launch acgi in WebCat (1997) Bug Report, maybe (1997) Mozilla/4. and Browser Info.txt (1997) [WebDNA] WebDNA and macOS 10.4 Mojave - Operational? (2018) [Announce] Newest Commerce Site based on WebCatalog (1997)