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 = 41784
interpreted = N
texte = 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] [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)
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] [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/ Gary Krockover

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:

Announcing general availability of WebDNA 4.5 release (2002) Logging purchases (1997) authorizenet/webmerchant (2000) multi-paragraph fields (1997) ReturnRaw context (1997) Hiding usernames and passwords in URL (1998) emailer (1997) WebCatalog Help (2002) ThreadMem ignored? (1998) Freeze (2003) ShowNext (was New WebCatalog Site) (1997) A question on sub-categories (1997) WebCat2 - Getting to the browser's username/password data (1997) [convertchars] Problem (2000) [shownext max=?] armed (1997) Add a field to the error log? (1997) permission deny help please (2004) WebCat2.0 [format thousands .0f] no go (1997) Answer: WebDelivery downloads alias, not original ? (1997) Showing unopened cart (1997)