Re: Date range

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 63859
interpreted = N
texte = It's the exclamation point. [showif [x]![y]] ...stuff... [/showif] On Sat, 21 Jan 2006 14:15:20 -0500 sbraun wrote: > 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/ ------------------------------------------------------------- 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)
It's the exclamation point. [showif [x]![y]] ...stuff... [/showif] On Sat, 21 Jan 2006 14:15:20 -0500 sbraun wrote: > 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/ ------------------------------------------------------------- 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/ "Dan Strong"

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:

Rumpus & WebCat (1998) Comments in db? (1997) Limiting user access to .tmpl files (1997) Problem about [CART] number (1998) Database causes out of memory error (2000) More questions about serial number dishing (1997) Can't get appendfile to work (1997) Nested tags count question (1997) Verbose error reporting (1998) Search/sort in URL Was: GuestBook example (1997) [WebDNA] TLS 1.2 and [tcpconnect] (2018) [OT] Games (2005) FEA REQ: One .hdr, multiple .db's (2003) For those of you not on the WebCatalog Beta... (1997) Secure Sever and showcart errors (1997) WSDL Wizard (2003) WebSTAR 2.1 freezes my Mac (1997) Database wiped clean (2005) Too Much Rootbeer Free Offer (1997) HTML Mail & Line breaks... (2004)