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:

Using Plug-In while running 1.6.1 (1997) Searchable WebCat (etc.) Docs ? (1997) Custom WebCat Prefs ... (1997) code to phantom spacing (2001) Message Board (1998) Summing fields (1997) Public beta 5 of WebCatalog 4.0 is now available (2000) Mac OS and 3.0.5b12 bug report (1999) Printing a final order (1997) shipcost (1997) RE: Problems with dbcatalog.exe (1997) Make sure I understand this??? (1997) Forms Search Questions (1997) [SearchString] problem with [search] context (1997) [WebDNA] Working Authorize.net script if you wanna post... (2020) Buying sans cart (1997) Re:Need help... (1997) [OT] See Flash? (2003) Grep help, please ... (2003) Error & Problem (1997)