Re: Search for starts with and ends with?

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47321
interpreted = N
texte = This will work fine if none of the last 4 characters conflict with the logic.for example. if there was: F00L G00S G00L S00LA contains S search would also find the S00L instead of only G00S[search] [founditems] [search] [founditems] results [/founditems] [/search] [/founditems] [/search]Donovan Gary Krockover wrote:>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. > >GK > > > > >>How can I do this search - I want to search for an SKU that starts with >>something and ends with a character. >> >>For example, my SKU's look like this: >> >>112233F00L >>114455G00S >>112233G00L >> >> >>I want to find all SKU's that start with 112233, AND end with L. >> >>Is there a way to do that, or a way to check the last digit when im doing >>the [showitems]? >> >>Thanks, >>Scott >> >> > > >------------------------------------------------------------- >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/ > > >-- -Donovan Brooke -Administrator of IT / -Assc. Art Director -Creative Services -Epsen Hillmer Graphics-402.342.1169 ------------------------------------------------------------- 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)
This will work fine if none of the last 4 characters conflict with the logic.for example. if there was: F00L G00S G00L S00LA contains S search would also find the S00L instead of only G00S[search] [founditems] [search] [founditems] results [/founditems] [/search] [/founditems] [/search]Donovan Gary Krockover wrote:>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. > >GK > > > > >>How can I do this search - I want to search for an SKU that starts with >>something and ends with a character. >> >>For example, my SKU's look like this: >> >>112233F00L >>114455G00S >>112233G00L >> >> >>I want to find all SKU's that start with 112233, AND end with L. >> >>Is there a way to do that, or a way to check the last digit when im doing >>the [showitems]? >> >>Thanks, >>Scott >> >> > > >------------------------------------------------------------- >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/ > > >-- -Donovan Brooke -Administrator of IT / -Assc. Art Director -Creative Services -Epsen Hillmer Graphics-402.342.1169 ------------------------------------------------------------- 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/ Donovan

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:

WC2b12: Yes, Formulas.db is for real (1997) Add more fields to an existent data base (1997) [cart] clarification... (1997) HTML Editors (1997) PCS Frames (1997) Not really WebCat (1997) Banner Ad example (Typhoon) and WebCatalog (1997) Unexpected error (1997) random sorting broken (was Re[2]: php vs WebCatalog) (2000) [WebDNA] HMAC-SHA1 Encryption (2013) Online reference (1997) [OT] See QT? (Was Eaaaasy FTP...) (2003) Image upload (2000) Applescript, WebDNA, and PDF (1997) Multiple Ad databases? (1997) Adding Shipping Fields (1999) Banner Ads (2000) help (2001) japanese characters (1997) [Announce] WebCatalog 3.0 Beta Program (1998)