× If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html

Alphabox with EXACT query

  • j.serafin.itprodesign
  • Offline
More
2 years 2 months ago #6450 by j.serafin.itprodesign
Alphabox with EXACT query was created by j.serafin.itprodesign
Hi.
Please tell me how could I make searching process by letters in "alphabox" but not as LIKE query but EXACT? I mean, that I need click some uncommon letter like „ñ” and I want to see only records that have „ñ” as first letter. I don’t want to see results with normal „n” etc. I know that is possible in "searchfield" but I need it in "alphabox"!
I need this results with exact query in mian field, I mean „Title-, name- or headlinefield” which is set in backend in component settings.

I have been waiting for your response (via email service@...) for over 3 weeks. How long do I have to wait for your attention?
Best Regards
Jaroslaw

Please Log in to join the conversation.

More
2 years 2 months ago #6452 by Dirk
Replied by Dirk on topic Alphabox with EXACT query
If you want LIKE to be exact you must change the collation of your column to utf8_bin

Extract the attached file to /components/com_joodb/plugins/letterssp.php
and replace {joodb alphabox} with {joodb letterssp}

Attachment letterssp.php_2022-01-26.zip not found



Be aware that Like and utf8_bin selects case sensitive
LIKE 'a%' finds apple but not Apple or Äpple

This message has an attachment file.
Please log in or register to see it.

Please Log in to join the conversation.

  • j.serafin.itprodesign
  • Offline
More
2 years 2 months ago #6466 by j.serafin.itprodesign
Replied by j.serafin.itprodesign on topic Alphabox with EXACT query
Hi.
Thank you for your help but this solution does not work. I changed the collation for the search column but unusual letters like ñ or ç when clicking on a letter in a row {joodb letterssp} simply do not respond. This does not work. What to do next? Should I change the collation for all columns? Any other solution?
Best regards
Jaroslaw

Please Log in to join the conversation.

  • j.serafin.itprodesign
  • Offline
More
2 years 2 months ago #6489 by j.serafin.itprodesign
Replied by j.serafin.itprodesign on topic Alphabox with EXACT query
Hello, is there anyone there? Over a week without an answer? A strange way to take care of customers...

Please Log in to join the conversation.

  • j.serafin.itprodesign
  • Offline
More
2 years 1 month ago #6557 by j.serafin.itprodesign
Replied by j.serafin.itprodesign on topic Alphabox with EXACT query
Hellooooooooooo!
Is there anyone there? Anyone?

Please Log in to join the conversation.

Moderators: Dirkjoest