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:

Grep and convertchars (2003) Intermitent problem using [referrer] (1997) [isfile] ? (1997) CVS Files for databases (2000) EMailCompleted folder - How to process tags (2000) general email error -1 (2007) Showing unopened cart (1997) [WebDNA] testing (2012) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) mass mailing (1998) show all problem (1997) help needed: Non-english characters in WebCatalog (1997) Protect and Serve (1999) [protect admin] (1997) Searching Dates (2000) [WebDNA] Admin Login Required to Serve any TPL Page (2009) What am I missing (1997) Virtual hosting and webcatNT (1997) [WriteFile] problems (1997) Internal Include Call/Request (2003)