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:

    
  1. Re: creating an index based on first letter of word inspecific field in database (dale 2002)
  2. Re: creating an index based on first letter of word inspecific field in database (Gary Krockover 2002)
  3. Re: creating an index based on first letter of word inspecific field in database (Anup Setty 2002)
  4. Re: creating an index based on first letter of word inspecific field in database (dale's stuff 2002)
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)