Re: search / summary

This WebDNA talk-list message is from

2005

It keeps the original formatting. numero = 63184
interpreted = N
texte = If you're going to store formatted dates in a database field, you shouldstore them in webdna's default mm/dd/yyyy format, not in a format youcreated yourself. Therefore I suggest that you change all - to / in yourdate fields, then try again. If you want the date to be displayed with - instead of / on your webpages, you can easily do this via grep or format or even getchars ... :)Sincerely,Kenneth Gromewww.kengrome.com>I store the post date in the db as>03-02-2005>04-04-2005>05-16-2005>etc.>>I'm trying to create an archive of all the posts in>any given month for individuals....>>using "bw" works just fine like so......>>[Search>db=^/eb/blogs.db&eqBlogBydatarq=[blog>ger]&eqVisibleDatarq=Yes&bwBlogDatedatarq=04]>[showif [numfound]!0]April>2005
[/showif]>[/Search] >>But I'd have to have up to 12 searches per page to do>a year. Seems like a lot of searches on many many>individual pages each time they are hit or not too big>a concern??>>Can i somehow search just the first 2 characters of>that db field?? >>It seems I can't, and summarize doesn't seem to work>since I'm storing the date in the "04-04-2005" format.>>>(I'm still using 4.5 with IIS but vers 6.0 upgrade>looks like something I may need to do real soon.....)-------------------------------------------------------------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:

Re: search / summary ( Lester 2005) Re: search / summary ( "Kenneth Grome" 2005) Re: search / summary ( Lester 2005) Re: search / summary ( "Kenneth Grome" 2005) search / summary ( Lester 2005)

If you're going to store formatted dates in a database field, you shouldstore them in webdna's default mm/dd/yyyy format, not in a format youcreated yourself. Therefore I suggest that you change all - to / in yourdate fields, then try again. If you want the date to be displayed with - instead of / on your webpages, you can easily do this via grep or format or even getchars ... :)Sincerely,Kenneth Gromewww.kengrome.com>I store the post date in the db as>03-02-2005>04-04-2005>05-16-2005>etc.>>I'm trying to create an archive of all the posts in>any given month for individuals....>>using "bw" works just fine like so......>>[Search>db=^/eb/blogs.db&eqBlogBydatarq=[blog>ger]&eqVisibleDatarq=Yes&bwBlogDatedatarq=04]>[showif [numfound]!0]April>2005
[/showif]>[/Search] >>But I'd have to have up to 12 searches per page to do>a year. Seems like a lot of searches on many many>individual pages each time they are hit or not too big>a concern??>>Can i somehow search just the first 2 characters of>that db field?? >>It seems I can't, and summarize doesn't seem to work>since I'm storing the date in the "04-04-2005" format.>>>(I'm still using 4.5 with IIS but vers 6.0 upgrade>looks like something I may need to do real soon.....)-------------------------------------------------------------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/ "Kenneth Grome"

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:

Customizing WebDelivery.html (1998) Formating Tables w/[founditems] (1998) and vs or vs not (1998) remotely add + sign (1997) Separate SSL Server (1997) 301 redirect (2008) Sort Order on a page search (1997) Converting SQL Microtime to Date and Time (2003) RequiredFields (2000) Errata: WCS Newbie question (1997) Clickable maps and WebCatalog? (1996) WebCatalog for guestbook ? (1997) DB Field Name? (2000) Don't tick me off :) [elaspedtime] (1997) Deleting Multiple Database Records based on Checkbox (1998) Initiating NewCart (1997) Validation (2000) spook tcpconnect? (1999) $purchase WITHOUT creditcar (1997) thankyou.tmpl (1997)