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:

woops - speed results - right subject (2002) [WebDNA] Migration to linux/apache from IIS (2012) Migrating to NT (1997) WebCat2: multiple currency support (1997) WebCatalog can't find database (1997) disappearing SKU (etc.) fields (1998) faxing orders (2000) displaying 12 results 4 by 3 (2000) Re:2nd WebCatalog2 Feature Request (1996) WebCat2: Items xx to xx shown, etc. (1997) DON'T use old cart file! (1997) [input] [/input] (1997) Anyone using Editize (inline html editor) w/ WebDNA (2003) unitshipcost vs shipcosts (1997) Am I going senile? (Price recalc based on quantity) (1997) Date format problems (1997) Pre-flight public flag (1997) b12 cannot limit records returned and more. (1997) .eml files (2001) [WebDNA] How to valuate a domain name? (2010)