Re: This [search] worked before update to 4.5.1

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48507
interpreted = N
texte = [name] isn't a reserved word is it? Or more specifically, has it become one in 4.5.1? I dunno...What's your [numfound] after the 2nd search? I wonder if it's just bypassing the showif and adding 1 to numfound no matter how many are found.GK> Gary- > > On Thursday, March 6, 2003, at 09:01 PM, Gary Krockover wrote: > > > 1. Should neordernumdata be required: neordernumdatarq= ? > > That hasn't made a difference > > > > 2. Should group1field and group2field be declared as date types? > > Dunno. It finds the records it should without it. > > > > > 3. Where is the value for [name] being calculated (code not shown), > > could it > > be something in there? > > > > GK > > > > The first search finds all of the records it should in orders db. It > should provide [name] for the inner search. This page is an admin > template which displays all of the found records later on down the > page, so I know the first search is providing [name], because it's > showing up lower on the page. > > > > > > > > > > >> This snippet is supposed to calculate the number of new customers in a > >> given time frame. It was working before the most recent WebDNA update > >> (4.5.1), now it's not. Nothing changed on the page. > >> > >> > >> [math]newcust=0[/math] > >> > >> [search > >> db=orders.db&neordernumdata=[blank]&group1field=orderdate&group2field= > >> or > >> derdate&gegroup1datarq=[startdate]&legroup2datarq=[enddate]] > >> > >> [founditems] > >> > >> [search db=orders.db&eqnamedatarq=[name]] > >> [showif [numfound]=1] > >> [math]newcust=[newcust]+1[/math] > >> [/showif] > >> [/search] > >> > >> [/founditems] > >> > >> [/search] > >> > >> Basically, [newcust] is always equalling 1 now... > >> > >> I'm stumped. Platform is OSX. > >> > >> ??? > >> -- > >> > >> Will Starck > >> NovaDerm Skincare Science > >> http://www.novaderm.com > >> wjs@novaderm.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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: This [search] worked before update to 4.5.1 (Kenneth Grome 2003)
  2. Re: This [search] worked before update to 4.5.1 (Brian Fries 2003)
  3. Re: This [search] worked before update to 4.5.1 (WJ Starck 2003)
  4. Re: This [search] worked before update to 4.5.1 (Gary Krockover 2003)
  5. Re: This [search] worked before update to 4.5.1 (Kenneth Grome 2003)
  6. Re: This [search] worked before update to 4.5.1 (WJ Starck 2003)
  7. Re: This [search] worked before update to 4.5.1 (Gary Krockover 2003)
  8. This [search] worked before update to 4.5.1 (WJ Starck 2003)
[name] isn't a reserved word is it? Or more specifically, has it become one in 4.5.1? I dunno...What's your [numfound] after the 2nd search? I wonder if it's just bypassing the showif and adding 1 to numfound no matter how many are found.GK> Gary- > > On Thursday, March 6, 2003, at 09:01 PM, Gary Krockover wrote: > > > 1. Should neordernumdata be required: neordernumdatarq= ? > > That hasn't made a difference > > > > 2. Should group1field and group2field be declared as date types? > > Dunno. It finds the records it should without it. > > > > > 3. Where is the value for [name] being calculated (code not shown), > > could it > > be something in there? > > > > GK > > > > The first search finds all of the records it should in orders db. It > should provide [name] for the inner search. This page is an admin > template which displays all of the found records later on down the > page, so I know the first search is providing [name], because it's > showing up lower on the page. > > > > > > > > > > >> This snippet is supposed to calculate the number of new customers in a > >> given time frame. It was working before the most recent WebDNA update > >> (4.5.1), now it's not. Nothing changed on the page. > >> > >> > >> [math]newcust=0[/math] > >> > >> [search > >> db=orders.db&neordernumdata=[blank]&group1field=orderdate&group2field= > >> or > >> derdate&gegroup1datarq=[startdate]&legroup2datarq=[enddate]] > >> > >> [founditems] > >> > >> [search db=orders.db&eqnamedatarq=[name]] > >> [showif [numfound]=1] > >> [math]newcust=[newcust]+1[/math] > >> [/showif] > >> [/search] > >> > >> [/founditems] > >> > >> [/search] > >> > >> Basically, [newcust] is always equalling 1 now... > >> > >> I'm stumped. Platform is OSX. > >> > >> ??? > >> -- > >> > >> Will Starck > >> NovaDerm Skincare Science > >> http://www.novaderm.com > >> wjs@novaderm.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://webdna.smithmicro.com/ Gary Krockover

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:

emailer (1997) WebCat2: multiple currency support (1997) exclusive db lock with webcat-3 ? (2000) emailer and bad addresses (1997) Mass Mail (2000) Price problem (1997) Snake Bites (1997) WebSTAR 2.1 freezes my Mac (1997) Creating folders and deleting files (1997) Emailer setup (1997) Pixo support? (1998) Search Engine questions ... (2002) Formulas.db + Users.db (1997) triggers busted on 5/31 (2000) [WebDNA] Domain upgrade questions (2009) Questions! (2000) More Shopping Cart Problems (2000) WebDNA Codes in Secure Mode (1997) Math (1997) 2.0 Info (1997)