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:

searchable list archive (1997) [addlineitems] (1997) WebCatalog2 Feature Feedback (1996) Adding Text (2000) Superfilous Characters (1998) learning PHP (2007) Extracting a filename (2004) credit card authorization question (1997) How is it done? (1998) BUG REPORT: Delete context ignores max parameter (1998) WebCat on Apache (2002) Shopping Cart Best Practices (2006) BACKGROUND (2000) [format 40s]text[/format] doesn't work (1997) upgrading (1997) WebDNA Quick Reference (Reserved Words) (2000) Upgrade Installation (1998) Problem with Formulas.db (1998) WebCat/Typhoon Status under Windows (1998) emptying shopping carts and orders folder (2004)