×
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
- Topic Author
- Offline
Less
More
- Posts: 19
- Thank you received: 0
3 years 1 month 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 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.
- Dirk
-
- Offline
Less
More
- Posts: 1222
- Thank you received: 226
3 years 1 month ago #6452
by Dirk
This message has an attachment file.
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}
Be aware that Like and utf8_bin selects case sensitive
LIKE 'a%' finds apple but not Apple or Äpple
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
- Topic Author
- Offline
Less
More
- Posts: 19
- Thank you received: 0
3 years 1 month 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
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
- Topic Author
- Offline
Less
More
- Posts: 19
- Thank you received: 0
3 years 1 month 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
- Topic Author
- Offline
Less
More
- Posts: 19
- Thank you received: 0
3 years 3 weeks ago #6557
by j.serafin.itprodesign
Replied by j.serafin.itprodesign on topic Alphabox with EXACT query
Hellooooooooooo!
Is there anyone there? Anyone?
Is there anyone there? Anyone?
Please Log in to join the conversation.
Moderators: Dirk, joest