Re: Date range

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 63857
interpreted = N
texte = Hey all, What's the best character to use in WebDNA for a not equal sign inside a [showif] when comparing two text variables? example: [showif [x] <> [y]] code if not equal [/showif] Thanks, sfb On Friday, January 20, 2006, at 11:26 AM, WebDna @ Inkblot Media wrote: > > Someone else (Tana Adams I believe) was just (Jan 6th) having this same > issue. Matthew Bohne offered the following code: > > -------------------------- > > Pseudo Code: > > //Grab the month and create a new variable called 'nextMonth' > [text]nextMonth=[math] [theMonth] + 1 [/math][/text] > [text]nextYear=[theYear][/text] > > //Test to see if nextMonth is greater than 12, if so reset it to 1 > (Jan) and > also add a year to nextYear [showif [nextMonth]>12] > [text][nextMonth]=1[/text] > [text][nextYear]=[math][theYear]+1[/math][/text] > [/showif] > > //Do your search > [search db=some.db&rnDatedatarq=[theMonth]/1/[theYear] > [nextMonth]/0/[nextYear]&Datetype=date] > > > This should grab everything within the range. Hope it helps. > > -Adam > ---------------------- > > I have not personally tried it, but it appears to be sound. Give it > try and > let us know if this helps. > > Just another lowly WebDna Developer, > Ron Kirkland > > > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of > Christophe Billiottet > Sent: Friday, January 20, 2006 7:56 AM > To: WebDNA Talk > Subject: Date range > > Hi everyone! > > we have a database with dates mm/dd/yy and we list results for > specific [month] and [year] like this: > > rnfecha_fact_comprdatarq=[month]/01/[year] [month]/31/[year] > &fecha_fact_comprtype=date > > I just noticed today that if [month]=11 and [year]=2005, then this > code sorts > > 11/01/05 to 12/01/05 INCLUDED (12/01/05 should be excluded) > > probably because there are only 30 days in November. My guess is > WebDNA recognizes "12/01/05" as "11/31/05". > > Is there another way to list results month by month without getting > this sort of behaviour? > > sincerely, > chris > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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: Date range Problem ( "David Bastedo" 2006)
  2. Re: Date range Problem ( Jesse Proudman 2006)
  3. Date range Problem ( "David Bastedo" 2006)
  4. Re: Date range ( Gary Krockover 2006)
  5. Re: Date range ( "Dan Strong" 2006)
  6. Re: Date range ( Gary Krockover 2006)
  7. Re: Date range ( sbraun 2006)
  8. Re: Date range ( Chris 2006)
  9. Re: Date range ( "WebDna @ Inkblot Media" 2006)
  10. Date range ( Chris 2006)
  11. Re: Date Range Issue ( Kenneth Grome 2006)
  12. Re: Date Range Issue ( "Tana Adams" 2006)
  13. Re: Date Range Issue ( Matthew Bohne 2006)
  14. Re: Date Range Issue ( "Adam O'Connor" 2006)
  15. Re: Date Range Issue ( Matthew Bohne 2006)
  16. Re: Date Range Issue ( Matthew Bohne 2006)
  17. Date Range Issue ( "Tana Adams" 2006)
  18. Re: Another date range search Q (Brian Fries 2002)
  19. Re: Another date range search Q (Gary Krockover 2002)
  20. Another date range search Q (Gary Krockover 2002)
  21. searching by date ranges (Alan 2000)
  22. Re: Date Range Search not working (Kenneth Grome 2000)
  23. Re: SEARCH DATE RANGE (Kenneth Grome 2000)
  24. SEARCH DATE RANGE (Robert Kudrle 2000)
  25. Re: SEARCH DATE RANGE (Conley Hanson 2000)
  26. Re: Showif date range comparison (Kenneth Grome 1999)
  27. Re: Showif date range comparison (es-sleestak 1999)
  28. Re: Showif date range comparison (Ben Weinberg 1999)
  29. Re: Showif date range comparison (Kenneth Grome 1999)
  30. Re: Showif date range comparison (Ben Weinberg 1999)
  31. Re: Showif date range comparison (John Jakovich 1999)
  32. Showif date range comparison (Ben Weinberg 1999)
  33. Re: date range (Gary Richter 1998)
  34. Re: Date Range works (John Hill 1997)
  35. Re: searching by date range help needed (Kenneth Grome 1997)
  36. Re: searching by date range help needed (grichter@panavise.com (Gary Richter) 1997)
  37. searching by date range help needed (grichter@panavise.com (Gary Richter) 1997)
  38. A workaround for handling date range search in yyyy/mm/dd form (w curt eggemeyer 1997)
  39. Re: Date Range search (Marty Schmid 1997)
Hey all, What's the best character to use in WebDNA for a not equal sign inside a [showif] when comparing two text variables? example: [showif [x] <> [y]] code if not equal [/showif] Thanks, sfb On Friday, January 20, 2006, at 11:26 AM, WebDna @ Inkblot Media wrote: > > Someone else (Tana Adams I believe) was just (Jan 6th) having this same > issue. Matthew Bohne offered the following code: > > -------------------------- > > Pseudo Code: > > //Grab the month and create a new variable called 'nextMonth' > [text]nextMonth=[math] [theMonth] + 1 [/math][/text] > [text]nextYear=[theYear][/text] > > //Test to see if nextMonth is greater than 12, if so reset it to 1 > (Jan) and > also add a year to nextYear [showif [nextMonth]>12] > [text][nextMonth]=1[/text] > [text][nextYear]=[math][theYear]+1[/math][/text] > [/showif] > > //Do your search > [search db=some.db&rnDatedatarq=[theMonth]/1/[theYear] > [nextMonth]/0/[nextYear]&Datetype=date] > > > This should grab everything within the range. Hope it helps. > > -Adam > ---------------------- > > I have not personally tried it, but it appears to be sound. Give it > try and > let us know if this helps. > > Just another lowly WebDna Developer, > Ron Kirkland > > > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of > Christophe Billiottet > Sent: Friday, January 20, 2006 7:56 AM > To: WebDNA Talk > Subject: Date range > > Hi everyone! > > we have a database with dates mm/dd/yy and we list results for > specific [month] and [year] like this: > > rnfecha_fact_comprdatarq=[month]/01/[year] [month]/31/[year] > &fecha_fact_comprtype=date > > I just noticed today that if [month]=11 and [year]=2005, then this > code sorts > > 11/01/05 to 12/01/05 INCLUDED (12/01/05 should be excluded) > > probably because there are only 30 days in November. My guess is > WebDNA recognizes "12/01/05" as "11/31/05". > > Is there another way to list results month by month without getting > this sort of behaviour? > > sincerely, > chris > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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/ sbraun

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:

Great product and great job ! (1997) Not really WebCat (1997) Extended [ConvertChars] (1997) WebCatalog 4.0.2b5 available (2000) Pop-Up Redirects (1998) form data submission gets truncated (1997) Update quantity (2000) Modifying order output (1997) [WebDNA] sem_open bugfix for os x version 6.2 (2012) Press Release hit the NewsWire!!! (1997) WebDNA Threaded Discussions? (2004) [addlineitems] display (1997) show all problem (1997) XML Parse with XML WebDNA Syntax... (2004) [OT] Server check please (2006) Nested search (1997) Error Log.db --however (1997) Search in 2 or more catalogs (1997) Not Authorised Adding Items (1998) WebMerchant 1.6 and https (1997)