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:

Lambada for Macintosh is Here! (1996) Help me... (1998) what's wrong with this picture (2006) WebCatalog can't find database (1997) Checking Out! (1999) Encryption of E-mail (1998) [WebDNA] [BULK] WebDNA 6.2 or 7.x Hosting (might be) Needed (2011) Protect Tag (2003) WebCatalog 4.0.1 has been released! (2000) Round up prices (2000) b12 cannot limit records returned and more. (1997) Quit revisited (1997) [writefile] (1997) form data submission gets truncated (1997) RE: Formulas.db + Users.db (1997) %@#*& back button!!! (1999) WebMerchant/MacAuthorize (1998) [OT] Mom's gift (2006) Mac Vs WindowsNT (1997) problems with 2 tags (1997)