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:

Banner DNA (1997) Emailer pref's won't save (2005) [OT] CSS and SSI books (2004) Clean Code: Rules for inserting keyboard returns? (1997) Header info in content (1998) WebCat 3.04-3.07 plug-in dying on server.... (2000) Whats up with emailer? (1998) Search returns all, not 20 (1997) GuestBook example (1997) Part Html part WebDNA (1997) [url] link (1998) WebCatalog Prefs.ref file ? (1998) Bug with sendmail under RedHat (2006) HTML Editors (1997) Secure Server (1997) PCS Frames (1997) no time stamp & different times from emailer (1998) SetHeader (1997) File Upload (1997) URL too Long? (1997)