Re: Date problem still...

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56109
interpreted = N
texte = HI Scott, Yes I do have it set to Day/Month/Year (European)... on 2/14/04 10:04 PM, Scott Anderson at sanderson@smithmicro.com wrote: > Do you have your 'Read Date Format' Pref set to 'Day/Month/Year (European)'? > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of > Alan White > Sent: Friday, February 13, 2004 8:56 AM > To: WebDNA Talk > Subject: Date problem still... > > > Hello again, > > After the discussion that has just taken place I am going to write a full > question and see if I get a full answer :D > > My date thing still isn't working and I will post the exact code that I am > using so you can see what I am doing. > > Before I start I will tell you that my date prefs are set to : > > %d%m%Y > > Century break is set to : 00 > > the page I am trying to work with is as follows http://www.hanon-shop.com > (please follow the link to newsletter to get all the perams) > > The link should pass the variable [mth] to the news letter and then the > newsletter page calls 2 includes onto the page. > > a) mth.inc > b) display_mths.inc > > I will show you and extract from mth.inc like I have done before but I will > show you for the first 3 mths so you get how I have done it... > > ------------------------------ > > | [search > db=directory/directory/database.dbnews.db&rnnewsDatedatarq=01/01/04 > 31/01/04&newsDatetype=date] > [if [numfound]>0] > [then] > > JAN | > [/then] > [else] > JAN | > [/else] > [/if] > [/search] > > [search db=directory/directory/database.db&rnnewsDatedatarq=01/02/04 > 29/02/04&newsDatetype=date] > [if [numfound]>0] > [then] > > FEB | > [/then] > [else] > FEB | > [/else] > [/if] > [/search] > > [search db=directory/directory/database.db&rnnewsDatedatarq=01/03/04 > 31/03/04&newsDatetype=date] > [if [numfound]>0] > [then] > > MAR | > [/then] > [else] > MAR | > [/else] > [/if] > [/search] > > > This is what makes up the month navigation bar and the idea is that it will > only show a link to that month if there is information available. The > default month is specified from the link on our home pages and other > navigation menus. > > The second piece of code I am going to show you is from the display_mths.inc > which is what makes up the different items on the newsletter based upon the > [mth] variable passed from the menu shown in the previous snippet. I have > removed the formatting from the html portion for ease of display for the > benefit of those helping... > > ------------------------------ > > > [showif [mth]=jan][text]searchterm=rnnewsDatedatarq=01/01/04 > 31/01/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=feb][text]searchterm=rnnewsDatedatarq=01/02/04 > 29/02/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=mar][text]searchterm=rnnewsDatedatarq=01/03/04 > 31/03/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=apr][text]searchterm=rnnewsDatedatarq=01/04/04 > 30/04/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=may][text]searchterm=rnnewsDatedatarq=01/05/04 > 31/05/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=jun][text]searchterm=rnnewsDatedatarq=01/06/04 > 30/06/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=jul][text]searchterm=rnnewsDatedatarq=01/07/04 > 31/07/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=aug][text]searchterm=rnnewsDatedatarq=01/08/04 > 31/08/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=sep][text]searchterm=rnnewsDatedatarq=01/09/04 > 30/09/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=oct][text]searchterm=rnnewsDatedatarq=01/10/04 > 31/10/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=nov][text]searchterm=rnnewsDatedatarq=01/11/04 > 30/11/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=dec][text]searchterm=rnnewsDatedatarq=01/12/04 > 31/12/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > > [search db=newsletter/db_s/news.db&[searchterm]] > [founditems] > > [newsDate] > [Title] > [convertchars][Blurb][/convertchars] > [hideif [image1]=][/hideif] > [hideif [image2]=][/hideif] > > [/founditems] > [/search] > > ----------------------------------- > > My problem is that this *exact* code was running before out crash incident > the other day, the code still runs now, the difference being that the year > 03 is being looked up but 04 is not recognised. The code is working for OCT > and NOV 03 but not for JAN FEB this year. > > In theory according to the code above, this should not be possible. > > Now if there are flaws in my coding style I am aware that I am still a > relative newbie and I welcome any advice as to coding practices etc > (especially fusebox if anyone want to contact me off list) but all I want to > reslove just now is why this is not working because it was... > > Hope you can help and if you need any further clarification then please feel > free to ask me any questions about it. > > Thanks in advance and I apologise for repeating my problem I just want > answers goddamit!!! > > Thanks to all who have helped so far... > > 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/ > > > ------------------------------------------------------------- > 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 problem still... ( Alan White 2004)
  2. Re: Date problem still... ( "Scott Anderson" 2004)
  3. Re: Date problem still... ( Alan White 2004)
  4. Date problem still... ( Alan White 2004)
HI Scott, Yes I do have it set to Day/Month/Year (European)... on 2/14/04 10:04 PM, Scott Anderson at sanderson@smithmicro.com wrote: > Do you have your 'Read Date Format' Pref set to 'Day/Month/Year (European)'? > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of > Alan White > Sent: Friday, February 13, 2004 8:56 AM > To: WebDNA Talk > Subject: Date problem still... > > > Hello again, > > After the discussion that has just taken place I am going to write a full > question and see if I get a full answer :D > > My date thing still isn't working and I will post the exact code that I am > using so you can see what I am doing. > > Before I start I will tell you that my date prefs are set to : > > %d%m%Y > > Century break is set to : 00 > > the page I am trying to work with is as follows http://www.hanon-shop.com > (please follow the link to newsletter to get all the perams) > > The link should pass the variable [mth] to the news letter and then the > newsletter page calls 2 includes onto the page. > > a) mth.inc > b) display_mths.inc > > I will show you and extract from mth.inc like I have done before but I will > show you for the first 3 mths so you get how I have done it... > > ------------------------------ > > | [search > db=directory/directory/database.dbnews.db&rnnewsDatedatarq=01/01/04 > 31/01/04&newsDatetype=date] > [if [numfound]>0] > [then] > [cart]&RA=[random]"> > JAN | > [/then] > [else] > JAN | > [/else] > [/if] > [/search] > > [search db=directory/directory/database.db&rnnewsDatedatarq=01/02/04 > 29/02/04&newsDatetype=date] > [if [numfound]>0] > [then] > [cart]&RA=[random]"> > FEB | > [/then] > [else] > FEB | > [/else] > [/if] > [/search] > > [search db=directory/directory/database.db&rnnewsDatedatarq=01/03/04 > 31/03/04&newsDatetype=date] > [if [numfound]>0] > [then] > [cart]&RA=[random]"> > MAR | > [/then] > [else] > MAR | > [/else] > [/if] > [/search] > > > This is what makes up the month navigation bar and the idea is that it will > only show a link to that month if there is information available. The > default month is specified from the link on our home pages and other > navigation menus. > > The second piece of code I am going to show you is from the display_mths.inc > which is what makes up the different items on the newsletter based upon the > [mth] variable passed from the menu shown in the previous snippet. I have > removed the formatting from the html portion for ease of display for the > benefit of those helping... > > ------------------------------ > > > [showif [mth]=jan][text]searchterm=rnnewsDatedatarq=01/01/04 > 31/01/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=feb][text]searchterm=rnnewsDatedatarq=01/02/04 > 29/02/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=mar][text]searchterm=rnnewsDatedatarq=01/03/04 > 31/03/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=apr][text]searchterm=rnnewsDatedatarq=01/04/04 > 30/04/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=may][text]searchterm=rnnewsDatedatarq=01/05/04 > 31/05/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=jun][text]searchterm=rnnewsDatedatarq=01/06/04 > 30/06/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=jul][text]searchterm=rnnewsDatedatarq=01/07/04 > 31/07/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=aug][text]searchterm=rnnewsDatedatarq=01/08/04 > 31/08/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=sep][text]searchterm=rnnewsDatedatarq=01/09/04 > 30/09/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=oct][text]searchterm=rnnewsDatedatarq=01/10/04 > 31/10/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=nov][text]searchterm=rnnewsDatedatarq=01/11/04 > 30/11/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > [showif [mth]=dec][text]searchterm=rnnewsDatedatarq=01/12/04 > 31/12/04&newsDatetype=date&denewsDatesort=1[/text][/showif] > > [search db=newsletter/db_s/news.db&[searchterm]] > [founditems] > > [newsDate] > [Title] > [convertchars][Blurb][/convertchars] > [hideif [image1]=][/hideif] > [hideif [image2]=][/hideif] > > [/founditems] > [/search] > > ----------------------------------- > > My problem is that this *exact* code was running before out crash incident > the other day, the code still runs now, the difference being that the year > 03 is being looked up but 04 is not recognised. The code is working for OCT > and NOV 03 but not for JAN FEB this year. > > In theory according to the code above, this should not be possible. > > Now if there are flaws in my coding style I am aware that I am still a > relative newbie and I welcome any advice as to coding practices etc > (especially fusebox if anyone want to contact me off list) but all I want to > reslove just now is why this is not working because it was... > > Hope you can help and if you need any further clarification then please feel > free to ask me any questions about it. > > Thanks in advance and I apologise for repeating my problem I just want > answers goddamit!!! > > Thanks to all who have helped so far... > > 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/ > > > ------------------------------------------------------------- > 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:

What abobut variables named max ??? (2000) Trigger to restart Webcat Service (2001) Almost a there but..bye bye NetCloak (1997) Appending current [date] to a database (1997) Part 2 - [showif] if variable exists (1998) Removing [showif] makes a big difference in speed (1997) Webmerchant (1999) Can you do this??? and other stuff (1997) Username for Admin Group (1997) Hard Questions ? (1997) WC2b12: Yes, Formulas.db is for real (1997) WebCat & WebTen (1997) All choices on IE different than Netscape (1997) 2.01 upgrade problems (1997) How long until WebDNA makes the list? :( (2004) [isfile] ? (1997) [shownext] support - MacOS (1997) Alias and MacOs X (2003) access denied problem (1997) webcatalog approaching max (1998)