Re: search / summary
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63188
interpreted = N
texte = grep is in 4.5I'll give it a go in a bitthanks--- Kenneth Grome
wrote:> >Would I change the format of the entries in the .db> >from 09-01-2005 to 09/01/2005 using grep??> > If grep is in version 4.5 (sorry I don't remember at> the moment and I'm> too lazy to look it up) just try this AFTER making a> backup copy of your> database, replacing "dbfn" with your database field> name, and replacing> "your.db" with the proper path to your database:> > [search db=your.db&neskudatarq=[blank]]> [founditems]> [replace db=your.db&eqskudatarq=[sku]]dbfn=[grep> search=-> &replace=/][dbfn][/grep][/replace]> [/founditems]> [/search]> > If grep is not in version 4.5 this will work> assuming all your dates are> in mm-dd-yyyy format. It's not as elegant as grep> but who cares, as long> as it works:> > [search db=your.db&neskudatarq=[blank]]> [founditems]> [replace db=your.db&eqskudatarq=[sku]]dbfn=[getchars> start=1&end=2][dbfn][/getchars]/[getchars> start=4&end=5][dbfn][/> getchars]/[getchars> start=7&end=10][dbfn][/getchars][/replace]> [/founditems]> [/search]> > For those of you who are wondering why I didn't> suggest> replacefounditems, he's still using version 4.5 --> and I don't think> replacefounditems is in version 4.5, is it?> > :)> > Sincerely,> Kenneth Grome> www.kengrome.com> > > > > > > >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> >digest@talk.smithmicro.com>> >Web Archive of this list is at:> http://webdna.smithmicro.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/> __________________________________ 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:
grep is in 4.5I'll give it a go in a bitthanks--- Kenneth Grome wrote:> >Would I change the format of the entries in the .db> >from 09-01-2005 to 09/01/2005 using grep??> > If grep is in version 4.5 (sorry I don't remember at> the moment and I'm> too lazy to look it up) just try this AFTER making a> backup copy of your> database, replacing "dbfn" with your database field> name, and replacing> "your.db" with the proper path to your database:> > [search db=your.db&neskudatarq=[blank]]> [founditems]> [replace db=your.db&eqskudatarq=[sku]]dbfn=[grep> search=-> &replace=/][dbfn][/grep][/replace]> [/founditems]> [/search]> > If grep is not in version 4.5 this will work> assuming all your dates are> in mm-dd-yyyy format. It's not as elegant as grep> but who cares, as long> as it works:> > [search db=your.db&neskudatarq=[blank]]> [founditems]> [replace db=your.db&eqskudatarq=[sku]]dbfn=[getchars> start=1&end=2][dbfn][/getchars]/[getchars> start=4&end=5][dbfn][/> getchars]/[getchars> start=7&end=10][dbfn][/getchars][/replace]> [/founditems]> [/search]> > For those of you who are wondering why I didn't> suggest> replacefounditems, he's still using version 4.5 --> and I don't think> replacefounditems is in version 4.5, is it?> > :)> > Sincerely,> Kenneth Grome> www.kengrome.com> > > > > > > >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> >digest@talk.smithmicro.com>> >Web Archive of this list is at:> http://webdna.smithmicro.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/> __________________________________ 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:
Cart Number Propagation (1997)
Templates on Unix & CGI on Mac? (1997)
$Append for Users outside the ADMIN group (1997)
Odd [math] behavior (2003)
Bug? (1997)
Kaaaaahhhhhhhnnnnnnn! (1997)
WebCatalog (1999)
WebDNA's portability (2007)
One per customer (2000)
Robots fill event log (1997)
Nested tags count question (1997)
Empty Shopping Carts? (1998)
[SHOWIF] (1997)
multi-paragraph fields (1997)
Extended [ConvertChars] (1997)
Error Lob.db records error message not name (1997)
Stopping bad HTML propagation ? (1997)
WebCat & WebTen (1997)
Questions (1998)
[WebDNA] WebDNA Crashing or Not **YES** (2008)