Re: search / summary

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 63185
interpreted = N
texte = Would I change the format of the entries in the .db from 09-01-2005 to 09/01/2005 using grep?? or some other way. --- Kenneth Grome wrote: > If you're going to store formatted dates in a > database field, you should > store them in webdna's default mm/dd/yyyy format, > not in a format you > created yourself. Therefore I suggest that you > change all - to / in your > date fields, then try again. > > If you want the date to be displayed with - instead > of / on your web > pages, you can easily do this via grep or format or > even getchars ... :) > > Sincerely, > Kenneth Grome > www.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/ >  __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.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:

    
  1. Re: search / summary ( Lester 2005)
  2. Re: search / summary ( "Kenneth Grome" 2005)
  3. Re: search / summary ( Lester 2005)
  4. Re: search / summary ( "Kenneth Grome" 2005)
  5. search / summary ( Lester 2005)
Would I change the format of the entries in the .db from 09-01-2005 to 09/01/2005 using grep?? or some other way. --- Kenneth Grome wrote: > If you're going to store formatted dates in a > database field, you should > store them in webdna's default mm/dd/yyyy format, > not in a format you > created yourself. Therefore I suggest that you > change all - to / in your > date fields, then try again. > > If you want the date to be displayed with - instead > of / on your web > pages, you can easily do this via grep or format or > even getchars ... :) > > Sincerely, > Kenneth Grome > www.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/ >  __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.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/ Lester

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:

Unexpected error (1997) Rendering out a page (1997) FileMaker and WebCat (1999) Enhanced Master Counter? (1997) [isfile] ? (1997) THANKS (1997) [WebDNA] Triggers not working (2011) Pull down menu for categories (2000) Emailer (1998) Question about replacing words (1998) [WebDNA] Problem with administration (2009) How flexible is Shipping? (1997) Country & Ship-to address & other fields ? (1997) Test (2002) Re[2]: 2nd WebCatalog2 Feature Request (1996) Passing radio check box value to itself... (2000) WebCat2b15MacPlugin - [protect] (1997) Sorting by date (1997) CPU Usage 165% (2005) using showpage and showcart commands (1996)