Re: Search for starts with and ends with?

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47322
interpreted = N
texte = You would have to separate out the results of the first search from the rest of the items by appending those results to a temporary database. The second search would obviously then be on that temp database only.If the search criteria is complex or can get complex, this is a good method, however I like Paul's suggestion for your scenario.GK | Ok, that makes sense, but how do I do two searches? | Im using a URL that does a command=search to do the 'first' search. | Then im doing [founditems] in that page. | How do I do a second search? | Thanks, | Scott | | | On 1/31/03 9:48 AM, 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/ 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)
You would have to separate out the results of the first search from the rest of the items by appending those results to a temporary database. The second search would obviously then be on that temp database only.If the search criteria is complex or can get complex, this is a good method, however I like Paul's suggestion for your scenario.GK | Ok, that makes sense, but how do I do two searches? | Im using a URL that does a command=search to do the 'first' search. | Then im doing [founditems] in that page. | How do I do a second search? | Thanks, | Scott | | | On 1/31/03 9:48 AM, 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/ 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:

ShowIf helper? (1998) question: webmerchant connection (1997) [OT] Airport Network (2003) [SHOWIF AND/OR] (1997) can WC render sites out? (1997) WebCat2b15MacPlugin - [protect] (1997) X etc.... (1999) Separate SSL Server (1997) problems with 2 tags (1997) Emailer (WebCat2) (1997) Does not begin with.... (2003) WebDNA 4.5 on CentOS (2006) Cart # Starting at 1000 (2000) WebCatalog can't find database (1997) Flash 4 Examples (2000) Add message to Order (1997) re:check boxes (1997) Unexpected error (1997) Requiring that certain fields be completed (1997) Auto conversion of URLs? (1998)