Re: [WebDNA] Substring Search
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113432
interpreted = N
texte = 1026There's still no way to search for the last x characters in a dbfield value, so using ss is probably as close as you'll get.After you've retrieved some results you can do additionalcomparisons via showif etc. to remove the values you don't want.Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 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 tothe mailing list
.To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
1026There's still no way to search for the last x characters in a dbfield value, so using ss is probably as close as you'll get.After you've retrieved some results you can do additionalcomparisons via showif etc. to remove the values you don't want.Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug 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)