Re: [WebDNA] search comparison: ends with
This WebDNA talk-list message is from 2016
It keeps the original formatting.
numero = 113293
interpreted = N
texte = 886There is a nice function in the old CMS:----------------------[function name=3DBackwards][text]length=3D[countchars][instring][/countchars][/text][loop start=3D[length]&end=3D1&advance=3D-1][getchars =start=3D[index]&end=3D[index]][instring][/getchars][/loop][/function][Backwards instring=3Dabcdef_12345]-----------------------For showif, this could be used to match ends with. (using begins with)[text]st=3Dmytext[/text][text]st=3D[Backwards instring=3D[st]][/text][showif [st]~txe]Match![/showif]I=92m not sure how to reverse a string value in a database.. so I think =maybe the ew param could be useful. It=92ll have to be replicated in =searching [table] as well.=20DonovanOn Dec 30, 2016, at 2:21 AM, Lawrence Banahan
=wrote:> How do you reverse the string?>=20> Le 30 d=E9c. 2016 06:23, "Matthew Bohne" =a =E9crit :> Reverse the string and use "bw".>=20>=20> On 12/29/2016 9:48 PM, Iphonzie wrote:> The "ends with" search will be a nice addition. Any chance we can get =an equivalent operator for if / showif?>=20> - Brian>=20> On Dec 29, 2016, at 5:05 AM, Kenneth Grome =wrote:>=20> Cool, thanks Chris.>=20> Regards,> Kenneth Grome> WebDNA Solutions> http://www.webdnasolutions.com> Web Database Systems and Linux Server Administration>=20>=20>=20> On 12/28/2016 11:10 PM, christophe.billiottet@webdna.us wrote:> This addition will be available in the next version, 8.6.>=20> - chris>=20>=20> On Dec 16, 2016, at 18:42, Kenneth Grome =wrote:>=20> Chris,>=20> How hard would it be to add a new search comparison that finds> records that END WITH a value?>=20> We have "bw" for begins with.> How about a new "ew" for ends with?>=20> Regards,> Kenneth Grome> WebDNA Solutions> http://www.webdnasolutions.com> Web Database Systems and Linux Server Administration>=20>=20>=20> ---------------------------------------------------------> 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>=20> ---------------------------------------------------------> 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>=20>=20>=20> ---------------------------------------------------------> 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---------------------------------------------------------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:
886There is a nice function in the old CMS:----------------------[function name=3DBackwards][text]length=3D[countchars][instring][/countchars][/text][loop start=3D[length]&end=3D1&advance=3D-1][getchars =start=3D[index]&end=3D[index]][instring][/getchars][/loop][/function][Backwards instring=3Dabcdef_12345]-----------------------For showif, this could be used to match ends with. (using begins with)[text]st=3Dmytext[/text][text]st=3D[Backwards instring=3D[st]][/text][showif [st]~txe]Match![/showif]I=92m not sure how to reverse a string value in a database.. so I think =maybe the ew param could be useful. It=92ll have to be replicated in =searching [table] as well.=20DonovanOn Dec 30, 2016, at 2:21 AM, Lawrence Banahan =wrote:> How do you reverse the string?>=20> Le 30 d=E9c. 2016 06:23, "Matthew Bohne" =a =E9crit :> Reverse the string and use "bw".>=20>=20> On 12/29/2016 9:48 PM, Iphonzie wrote:> The "ends with" search will be a nice addition. Any chance we can get =an equivalent operator for if / showif?>=20> - Brian>=20> On Dec 29, 2016, at 5:05 AM, Kenneth Grome =wrote:>=20> Cool, thanks Chris.>=20> Regards,> Kenneth Grome> WebDNA Solutions> http://www.webdnasolutions.com> Web Database Systems and Linux Server Administration>=20>=20>=20> On 12/28/2016 11:10 PM, christophe.billiottet@webdna.us wrote:> This addition will be available in the next version, 8.6.>=20> - chris>=20>=20> On Dec 16, 2016, at 18:42, Kenneth Grome =wrote:>=20> Chris,>=20> How hard would it be to add a new search comparison that finds> records that END WITH a value?>=20> We have "bw" for begins with.> How about a new "ew" for ends with?>=20> Regards,> Kenneth Grome> WebDNA Solutions> http://www.webdnasolutions.com> Web Database Systems and Linux Server Administration>=20>=20>=20> ---------------------------------------------------------> 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>=20> ---------------------------------------------------------> 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>=20>=20>=20> ---------------------------------------------------------> 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---------------------------------------------------------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.
Donovan Brooke
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 challenges default admin/admin password (2000)
No luck with taxes (1997)
[WebDNA] A new popuated field to a DB with 700.000 records (2009)
Download Question (1997)
WebCat b13 CGI -shownext- (1997)
Add to a field (1998)
RE: Which [index]? (1997)
vars (2000)
Multiple catalog databases and showcart (1997)
showif and cart (1997)
WebCat website for developers and hosters (2001)
[WebDNA] Processor Maxing out (2010)
Running _every_ page through WebCat ? (1997)
Credit Card Number checking (1997)
Can this be done? (1997)
Plugin or CGI or both (1997)
Ampersand Character (&) (1997)
[OT] Linux -> Winderz (2005)
Where is f2? (1997)
Forbidden CGI Error (1997)