Re: Search for starts with and ends with?

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47355
interpreted = N
texte = >Two searches. First find all the SKU's that contain 112233 and then the >second search of the first result set that finds all SKU's that have an L >in them.Instead of two searches, I would just use the group field technique and do one search. The only problem is that you want to find all records that END WITH L, but there's no webdna comparison for that, so if L appears anywhere but at the end of the sku you'll still have to use showif's inside your founditems in order to finally display the right records. Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Search for starts with and ends with? (Kenneth Grome 2003)
  2. Re: Search for starts with and ends with? (Gary Krockover 2003)
  3. Re: Search for starts with and ends with? (Donovan 2003)
  4. Re: Search for starts with and ends with? (Paul Willis 2003)
  5. Re: Search for starts with and ends with? (Scott Szretter 2003)
  6. Re: Search for starts with and ends with? (Gary Krockover 2003)
  7. Re: Search for starts with and ends with? (Gary Krockover 2003)
  8. Re: Search for starts with and ends with? (Donovan 2003)
  9. Search for starts with and ends with? (Scott Szretter 2003)
>Two searches. First find all the SKU's that contain 112233 and then the >second search of the first result set that finds all SKU's that have an L >in them.Instead of two searches, I would just use the group field technique and do one search. The only problem is that you want to find all records that END WITH L, but there's no webdna comparison for that, so if L appears anywhere but at the end of the sku you'll still have to use showif's inside your founditems in order to finally display the right records. Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- 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://webdna.smithmicro.com/ Kenneth Grome

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:

Shownext from POST (2000) question: back button prevention (1997) DataBaseHelper Flawed (1997) DNS Lookup 2 (2000) Interactive Online Docs Was: [OT] Mozilla | Was: R.I.P. (2003) Re:Review comparison by PC Magazine: Open for On-line Business (1997) Bug Report, maybe (1997) Showif Question (2001) psst (1997) [protect admin] (1997) WebDNA creates DUPLICATE SHOPPING CART NUMBERS (2004) updating with ProductEditor (1998) serial number generation (1997) Bug or syntax error on my part? (1997) WebCat Contest Please Clarify (1998) Conditional searching & displaying (1997) wrong input values? (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) Multiple postings (2000) WebCat2 - Getting to the browser's username/password data (1997)