What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

Emailer (1997) More on the email templates (1997) Using Cookie for client specific info? (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) Help name our technology! I found it (1997) WebDNA to Apache RewriteMap (2005) Protecting webdelivery (1997) WebMerchant 1.6 and SHTML (1997) Extended [ConvertChars] (1997) Webcatalog 4.02b5 Mac OS X headers (2000) problems with 2 tags shakur (1997) Generating Report Totals (1997) service stop and restart (1997) UPS Shipping Docs (Where To Go) (1999) include bug????? (1997) POST Datamissing? (1998) [numfound] for [listfiles] (1998) Summing fields (1997) OT: Just for a waste of time (2003) I'm new be kind (1997)