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:

Re[2]: New syntax feedback for 4.0 (2000) Group search doesn't work. (1997) Strange Anchor problem (2005) SQL Changes in 3.0.7? (2000) RE: Promise of future help (1998) WebStar Compatibility (thx) (2003) [WebDNA] Emailer breaking format (2015) [WebDNA] [OT] WebDNA Wiki - need grammar check / suggestions (2009) WebCatalog for Postcards ? (1997) Bug Report, maybe (1997) [WebDNA] Generating Excel File Via WebDNA (2010) Secure server question (1997) webmerchant/ Mac Auth. and CC refunds (1998) Memory Error message (1998) Re:Signal Raised (1997) creator code (1997) off topic