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:
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)