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]=]
![](newsletter/pics/[image1])
[/hideif]> [hideif [image2]=]
![](newsletter/pics/[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:
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)