Re: any idea

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56056
interpreted = N
texte = How does the grouping of date fields work? I could could I search groups 1-12 for different months I guess but it still doesn't explain why it has stopped working for this year... all of the months carried the year 03 and then I changed it at the beginning of the month for 04 as we had new stuff to post. Everything was working ok when I changed the months but the search I specified shouldn't even produce a numfound greater than one... on 2/12/04 2:19 PM, Matthew C. Bohne at matthew.bohne@benetela.com wrote: > Try grouping your date field as group 1 and then search for > everything genewsDatedatarq=(Low Date)&legroup1datarq=(High Date) > > Or, if it's not too big of a pain in the butt... [math] all your > dates going in to your db and then search for a number range instead > of a date range coming out. > > ---- Original Message ---- > From: alan@streethreds.com > To: WebDNA-Talk@talk.smithmicro.com > Subject: RE: any idea > Date: Thu, 12 Feb 2004 14:08:19 +0000 > >> Hi >> >> Does anyone have a suggestion why this would be returning a result >> for the >> year 03? I had a major issue with webdna bugging out yesterday and >> part of >> our site is no longer working to do with dates. The strange thing is >> that >> it *is* working but displaying last years results, I have checked to >> make >> sure the correct template is on the server but it is still returning >> the >> wrong result :( >> >> [search db=newsletter/db_s/news.db&rnnewsDatedatarq=01/10/04 >> 31/10/04&newsDatetype=date] >> [if [numfound]>0] >> [then] >> > href="newsletter.html?page=display&mth=oct&cart=[cart]&RA=[random]"> >> OCT | >> [/then] >> [else] >> OCT | >> [/else] >> [/if] >> [/search] >> >> Hope someone has an idea of what might be causing it. >> >> Alan >> >> >> ------------------------------------------------------------- >> 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/ > > ---- > "I've never known a musician who regretted being one. Whatever > else life gives you, music will never let you down. > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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: [WebDNA] Spawn operation stalling - any idea what might cause this? (Tom Duke 2013)
  2. Re: [WebDNA] Spawn operation stalling - any idea what might cause (matt@psiprime.com 2013)
  3. [WebDNA] Spawn operation stalling - any idea what might cause this? (Tom Duke 2013)
  4. Re: Does anyone have any ideas? ( "Olin Lagon" 2007)
  5. Does anyone have any ideas? ( "Scott Walters" 2007)
  6. Re: any idea ( Donovan Brooke 2004)
  7. Re: any idea ( "Scott Anderson" 2004)
  8. Re: any idea ( Gary Krockover 2004)
  9. Re: any idea ( Donovan Brooke 2004)
  10. Re: any idea ( Alan White 2004)
  11. Re: any idea ( Alan White 2004)
  12. Re: any idea ( Donovan Brooke 2004)
  13. Re: any idea ( "Matthew C. Bohne" 2004)
  14. Re: any idea ( "Matthew C. Bohne" 2004)
  15. Re: any idea ( Tom Brent 2004)
  16. any idea ( Alan White 2004)
  17. Re: Any idea why I am getting this error? (Bob McPeak 2001)
How does the grouping of date fields work? I could could I search groups 1-12 for different months I guess but it still doesn't explain why it has stopped working for this year... all of the months carried the year 03 and then I changed it at the beginning of the month for 04 as we had new stuff to post. Everything was working ok when I changed the months but the search I specified shouldn't even produce a numfound greater than one... on 2/12/04 2:19 PM, Matthew C. Bohne at matthew.bohne@benetela.com wrote: > Try grouping your date field as group 1 and then search for > everything genewsDatedatarq=(Low Date)&legroup1datarq=(High Date) > > Or, if it's not too big of a pain in the butt... [math] all your > dates going in to your db and then search for a number range instead > of a date range coming out. > > ---- Original Message ---- > From: alan@streethreds.com > To: WebDNA-Talk@talk.smithmicro.com > Subject: RE: any idea > Date: Thu, 12 Feb 2004 14:08:19 +0000 > >> Hi >> >> Does anyone have a suggestion why this would be returning a result >> for the >> year 03? I had a major issue with webdna bugging out yesterday and >> part of >> our site is no longer working to do with dates. The strange thing is >> that >> it *is* working but displaying last years results, I have checked to >> make >> sure the correct template is on the server but it is still returning >> the >> wrong result :( >> >> [search db=newsletter/db_s/news.db&rnnewsDatedatarq=01/10/04 >> 31/10/04&newsDatetype=date] >> [if [numfound]>0] >> [then] >> > href="newsletter.html?page=display&mth=oct&cart=[cart]&RA=[random]"> >> OCT | >> [/then] >> [else] >> OCT | >> [/else] >> [/if] >> [/search] >> >> Hope someone has an idea of what might be causing it. >> >> Alan >> >> >> ------------------------------------------------------------- >> 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/ > > ---- > "I've never known a musician who regretted being one. Whatever > else life gives you, music will never let you down. > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/ Alan White

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:

How flexible is Shipping? (1997) WebCatalog for WebStar V (2001) Trigger time setting (2002) Is there a max number of fields? (1998) Re:no [search] with NT (1997) New WebCatalog Version !!! (1997) Dubble Sku's in a Database (1999) Bug Report, maybe (1997) emailer (1997) RequiredFields notes ... (1997) Re:Multiple appends with checkboxes (1998) WCS Newbie question (1997) Multiple Merchant Accounts? (1997) list and stuff... (2004) Random sort is not random at all..... (2000) [WebDNA] [listallcontexts] ??? (2016) Forumulas.db & Variables (2002) SV: Mass Mail (2000) Approved Carts (1999) japanese characters (1997)