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:
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:
Showing once on a founditems (1997)
Developer Resource Center (2002)
I give up!! (1997)
international time (1997)
WebCatalog Serial Number (2003)
Standalone Testing (1998)
[WebDNA] OLD list archives? (2010)
Emailer Set Up (1997)
Using [Include] Context (1999)
search vs lookup (1998)
wild question (1998)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
(1997)
HomePage Caution (1997)
table import function crashes server (2008)
OSX Webcatalog Install (2001)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
PCS Emailer's role ? (1997)
One more browser problem to watch out for... (1997)