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:

Word Break (1999) Alternate Cookie location (2001) BUG REPORT -- FINAL (1999) WebCatalog for Postcards ? (1997) Shipcost lookup? (1997) sendmail and accented characters (1998) WebCatalog can't find database (1997) WebCat2b15MacPlugin - [protect] (1997) Cookie problems using Mozilla and Camino browsers (2004) [OT] Live Chat with Video capability (2008) search vs lookup (1998) Looking up two prices in database? (1997) Bug or syntax error on my part? (1997) Sorting Results (1999) Sorry for the simple Question.. (1999) multi-paragraph fields (1997) WebDNA for Dummies (2003) Help!!!! (1997) [sendmail] on NT? (1997) WebSTAR/WebCat is serving .db files! (1999)