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 .dbfrom 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:
Would I change the format of the entries in the .dbfrom 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)