re: date search problem

This WebDNA talk-list message is from

1999

It keeps the original formatting. numero = 24003
interpreted = N
texte = Assuming you don't want to change the database.... Yes I'm sure you can solvethe problem in WebCatalog (as long as you're using version 3.X).Here's a snippet that may get you started. The snippet doesn't solve yourwhole problem but it does the following: 1. Removes the date from the string;2. Figures out how many days there are in total including show and dark days;loops through the days to show when the show is on or off.[text]firstcut=[middle startafter=:&endbefore=2]1-1-99:1101111[/middle][/text][text]mycounter=[countchars][text]firstcut[/text][/countchars][/text]

[loop start=1&end=[text]mycounter[/text]&advance=1][showif 1=[getcharsstart=[index]&end=[index]][text]firstcut[/text][/getchars]]Show On

[/showif][showif 0=[getcharsstart=[index]&end=[index]][text]firstcut[/text][/getchars]]No Show

[/showif][/loop]If this helps and you need more just ask. Interesting problem. Regards,Al Booth(web designer)Want to see lots of interesting WebCat sites? Check my index at www.interlog.com/~albooth. Associated Messages, from the most recent to the oldest:

re: date search problem (Allen Booth 1999) re: date search problem (Allen Booth 1999)

Assuming you don't want to change the database.... Yes I'm sure you can solvethe problem in WebCatalog (as long as you're using version 3.X).Here's a snippet that may get you started. The snippet doesn't solve yourwhole problem but it does the following: 1. Removes the date from the string;2. Figures out how many days there are in total including show and dark days;loops through the days to show when the show is on or off.[text]firstcut=[middle startafter=:&endbefore=2]1-1-99:1101111[/middle][/text][text]mycounter=[countchars][text]firstcut[/text][/countchars][/text]

[loop start=1&end=[text]mycounter[/text]&advance=1][showif 1=[getcharsstart=[index]&end=[index]][text]firstcut[/text][/getchars]]Show On

[/showif][showif 0=[getcharsstart=[index]&end=[index]][text]firstcut[/text][/getchars]]No Show

[/showif][/loop]If this helps and you need more just ask. Interesting problem. Regards,Al Booth(web designer)Want to see lots of interesting WebCat sites? Check my index at www.interlog.com/~albooth. Allen Booth

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:

numlineitems possible cache problem. (2000) strangness with the form (2001) WC2.0 Memory Requirements (1997) WebCat B13 Mac CGI -- Frames question (1997) What am I doing wrong? (2000) Possible solution to malformed pages in NN (2000) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) It just Does't add up!!! (1997) Showif, Hideif reverse logic ? (1997) MAC versions of WebCatalog 2.1 and WebMerchant 2.1 (1998) Removing a character (2000) No luck with taxes (1997) Help getting [shownext] to increment (2003) Talk List Suggestions (1997) [WebDNA] Authenticating with Twitter OAuth API v1.1 (2013) ThisURL (2000) Ok here is a question? (1997) FEATURE REQUEST: (was: Summarizing results. Is there a shortcut? (1999) [format 40s]text[/format] doesn't work (1997) [WriteFile] problems (1997)