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. Iplayed 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 inthe database, the summ=T will strip out multiple instances of the samevalue, 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:
I think he's wanting it dynamically generated by what's in his database. Iplayed 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 inthe database, the summ=T will strip out multiple instances of the samevalue, 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)