Date problem still...
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56094
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
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:
Emailer choke (1997)
Shopping cart problem (2003)
[addlineitems] display (1997)
Encrypt Users.db problem (1998)
Which is Faster (1998)
Snake Bites (1997)
[WebDNA] how can i grab the contents of a post? (2011)
Summarising on two fields (1998)
Re:quit command on NT (1997)
[shownext max=?] armed (1997)
Mac Sever Web Hosting (1999)
Feature Request/Rant - Last-modified and Expires MIME (2000)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Using the sendmail command on CGate Pro (Unix) (2000)
[protect] error page (1997)
WebCatalog can't find database (1997)
A little syntax help (1997)
WebCatalog can't find database (1997)
Convert words (2002)
any idea (2004)