Re: [WebDNA] Substring Search

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113432
interpreted = N
texte = 1026 There's still no way to search for the last x characters in a db field value, so using ss is probably as close as you'll get. After you've retrieved some results you can do additional comparisons via showif etc. to remove the values you don't want. Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 03/01/2017 01:29 PM, frank@cwolfe.com wrote: > > Hi, > > Is this the correct syntax for subword search? "ss". The docs are > a little vague with the example that is provided. > > This does not work unless I use the full cart number. I was > hoping to search for the last 5 or 6 characters in the cart number. > > > [search > db=../customers/customer.db&eqCARTdata=[searchfor]&CARTWord=ss] > > > WebDNA 8.5 > > Thanks, > > Frank > > > --------------------------------------------------------- This > message is sent to you because you are subscribed to the mailing > list . To unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: > support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us . Associated Messages, from the most recent to the oldest:

    
  1. RE: [WebDNA] Substring Search ( 2017)
  2. Re: [WebDNA] Substring Search (Kenneth Grome 2017)
  3. [WebDNA] Substring Search ( 2017)
1026 There's still no way to search for the last x characters in a db field value, so using ss is probably as close as you'll get. After you've retrieved some results you can do additional comparisons via showif etc. to remove the values you don't want. Regards, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com Web Database Systems and Linux Server Administration On 03/01/2017 01:29 PM, frank@cwolfe.com wrote: > > Hi, > > Is this the correct syntax for subword search? "ss". The docs are > a little vague with the example that is provided. > > This does not work unless I use the full cart number. I was > hoping to search for the last 5 or 6 characters in the cart number. > > > [search > db=../customers/customer.db&eqCARTdata=[searchfor]&CARTWord=ss] > > > WebDNA 8.5 > > Thanks, > > Frank > > > --------------------------------------------------------- This > message is sent to you because you are subscribed to the mailing > list . To unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: > support@webdna.us --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us . 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:

BR (1997) Emailer Chokes on bad address (1997) Country & Ship-to address & other fields ? (1997) WebCatalog and WebMerchant reviewed by InfoWorld (1997) European Convention (2004) can WC render sites out? (1997) Secure Server (1999) [showif]/[hideif] question (1997) sorting and grouping (1998) PDF Tools (2006) Upload Progress Bar (2003) WebCat2 - Getting to the browser's username/password data (1997) 2nd WebCatalog2 Feature Request (1996) SHOWIF [var_with_backslash]^[value] (2002) Order file numbers different than the cart number. why? (2000) [WebDNA] HTML Symbol Entities (2009) Country & Ship-to address & other fields ? (1997) Re:WebCatalog/WebMerchant III (1998) 3 card formulas! (1999) Help! WebCat2 bug (1997)