Re: Search for starts with and ends with?
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47318
interpreted = N
texte = 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/ ------------------------------------------------------------- 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:
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/ ------------------------------------------------------------- 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/
Scott Szretter
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:
NT Processor Woes (2000)
Help! WebCat2 bug (1997)
how is this possible (2000)
Comments in db? (1997)
WC2.0 Memory Requirements (1997)
the comparison character \ (2000)
lookup (1998)
Looking up two prices in database? (1997)
WebDNA and SQL (2003)
lookups or math? (1998)
[OT] Forums - check it out (2005)
nslookup (2000)
Nav. 4 probs with cart - Serious problem (1997)
BugNote#1 - listdatabases fails on MacOS ... (2000)
Assigning carts (1998)
Unexpected error (1997)
problems with 2 tags shakur (1997)
serial number generation (1997)
PCS Customer submissions ? (1997)
Help with Repost Data msg from form (1997)