Re: [WebDNA] search comparison: ends with

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 113293
interpreted = N
texte = 886 There 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.=20 Donovan On 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 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] search comparison: ends with (Donovan Brooke 2016)
  2. Re: [WebDNA] search comparison: ends with (Lawrence Banahan 2016)
  3. Re: [WebDNA] search comparison: ends with (Matthew Bohne 2016)
  4. Re: [WebDNA] search comparison: ends with (Iphonzie 2016)
  5. Re: [WebDNA] search comparison: ends with (Kenneth Grome 2016)
  6. Re: [WebDNA] search comparison: ends with (christophe.billiottet@webdna.us 2016)
  7. Re: [WebDNA] search comparison: ends with (christophe.billiottet@webdna.us 2016)
  8. [WebDNA] search comparison: ends with (Kenneth Grome 2016)
886 There 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.=20 Donovan On 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 to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug 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)