Re: creating an index based on first letter of word inspecific field in database
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41786
interpreted = N
texte = Hi Gary,Yes, creating it dynamically was the idea. What I ended up doing, after playing aorund abit with summ=t was to create a new field where I store the first letter of the term. Then I use summ=t against that field.This also made things faster on the resulting results page where I pass the first letter to a template and display all results of terms beginning with that letter.Doing a search on eqFieldData=A is faster than bwFieldData=A Thanks to both you and Anup for your suggestions. I appreciate it.DaleOn Mon, 22 Jul 2002 08:38:23 Gary Krockover
wrote:> I think he's wanting it dynamically generated by what's in > his database. I> played around with it and came up with what Dale probably > has already,> something like:> > [search > db=somedb.db&neSKUdatarq=[blank]&SKUsumm=T&asSKUsort=1]> [founditems]> [text show=f]firstletter=[GetChars > start=1&end=1][SKU][/GetChars][/text]> href=results.html?command=search&db=somedb.db&bwSKUdatarq=[firstletter]&max> =30&asskusort=1&asmakesort=2>[firstletter]|> [/founditems]> [/search]> > However, it obviously will list the first letter for each > instance found in> the database, the summ=T will strip out multiple instances > of the same> value, but not for just the same firstletter.> > GK> > > > > A> > B> > :> > :> > Z> >> >> > In your page.htm you can do the search using the variable > >sBy> >> > [search db=some.db&bwFIELDdata=[sBy]&asFIELDsort=1]> >> >> > HTH> >> > - Anup> >> > ----- Original Message -----> > From: dale's stuff > > To: WebCatalog Talk > > Sent: Saturday, July 20, 2002 3:09 PM> > Subject: creating an index based on first letter of word in > >specific field> > in database> >> >> > > Hi,> > >> > > I want to provide a set of alphabetical links for the > >entries in a> > database> > > - think of an old style phone book> > >> > > not sure the best way to do this.> > >> > > Looking to have results like:> > >> > > A B C E F> > >> > > which would mean that there are words beginning with the > >letters A, B,> and> > > C, but no words beginning with the letter D in the > >database.> > >> > > The letters listed about will be links to a results page > >listing all the> > > words that begin with that respective letter.> > >> > > Ideas?> > >> > > Using WC 4.02 on Linux> > >> > > Thanks> > >> > > Dale> > -------------------------------------------------------------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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi Gary,Yes, creating it dynamically was the idea. What I ended up doing, after playing aorund abit with summ=t was to create a new field where I store the first letter of the term. Then I use summ=t against that field.This also made things faster on the resulting results page where I pass the first letter to a template and display all results of terms beginning with that letter.Doing a search on eqFieldData=A is faster than bwFieldData=A Thanks to both you and Anup for your suggestions. I appreciate it.DaleOn Mon, 22 Jul 2002 08:38:23 Gary Krockover wrote:> I think he's wanting it dynamically generated by what's in > his database. I> played around with it and came up with what Dale probably > has already,> something like:> > [search > db=somedb.db&neSKUdatarq=[blank]&SKUsumm=T&asSKUsort=1]> [founditems]> [text show=f]firstletter=[GetChars > start=1&end=1][SKU][/GetChars][/text]> href=results.html?command=search&db=somedb.db&bwSKUdatarq=[firstletter]&max> =30&asskusort=1&asmakesort=2>[firstletter]|> [/founditems]> [/search]> > However, it obviously will list the first letter for each > instance found in> the database, the summ=T will strip out multiple instances > of the same> value, but not for just the same firstletter.> > GK> > > > > A> > B> > :> > :> > Z> >> >> > In your page.htm you can do the search using the variable > >sBy> >> > [search db=some.db&bwFIELDdata=[sBy]&asFIELDsort=1]> >> >> > HTH> >> > - Anup> >> > ----- Original Message -----> > From: dale's stuff > > To: WebCatalog Talk > > Sent: Saturday, July 20, 2002 3:09 PM> > Subject: creating an index based on first letter of word in > >specific field> > in database> >> >> > > Hi,> > >> > > I want to provide a set of alphabetical links for the > >entries in a> > database> > > - think of an old style phone book> > >> > > not sure the best way to do this.> > >> > > Looking to have results like:> > >> > > A B C E F> > >> > > which would mean that there are words beginning with the > >letters A, B,> and> > > C, but no words beginning with the letter D in the > >database.> > >> > > The letters listed about will be links to a results page > >listing all the> > > words that begin with that respective letter.> > >> > > Ideas?> > >> > > Using WC 4.02 on Linux> > >> > > Thanks> > >> > > Dale> > -------------------------------------------------------------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://search.smithmicro.com/
dale
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:
[WebDNA] smtp authentication (2008)
WebCat2 several catalogs? (1997)
Wrapping text (1998)
[NT] ie 4.0 required (1997)
Further tests with the infamous shipCost (1997)
2nd WebCatalog2 Feature Request (1996)
Re:quit command on NT (1997)
Include Troubles (1998)
search same field twice??? (1999)
Help name our technology! (1997)
WebCat2 Append problem (B14Macacgi) (1997)
RE: Web*SSL and WebCatalog (1997)
no emailfolder errors? (2000)
WebStar 3 crackable !!!! (1998)
Conflicting WebStar Cache Settings? (2000)
Snake Bites (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Custom WebCat Prefs ... (1997)
WC1.6 to WC2 date formatting -FIXED! (1997)
Install problem (Was Bad Install) (2003)