Sorry for late response. We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Sorry to disappoint you but unfortunately variables in mysql queries are not supported. But you can use placeholders. You can take a look at our documentation about placeholders here.
Sorry about that. Here you can see the part of the ticket that can be useful for you.
Netflairreplied
Hi Milan,
i didnt know i could create a VIEW in phpmyadmin. This information really made my day.
It works perfectly now, thank you very much for your time and help.
Youreplied
Hi Patrick,
Whan you are using complicated SQL queries, my suggestion is to make a VIEW in phpmyadmin and see if that query returns the desired result. If the result is good , use that query
SELECT * FROM view_name
as an input when creating the tables with Add from data source option.
Netflair replied
Hi Milan,
thank you for your help so far. I got one more Error: SET not implemented.
Is there a way to implement it ? I am trying to use SET SQL_BIG_SELECTS=1; It works fine within PHPMyAdmin.
I want to display a table with a sequential number / rank for my table.
I'm not able to create User Variables or use "SET "in wpDataTables MYSQL
How can i do that without "SET" or User variables?
Example:
+----------+-----------+--------+ | User | Score | Rank | +----------+-----------+--------+ | Kathy | 3215 | 1 | | Jane | 3021 | 2 | | Nick | 2405 | 3 | | Bob | 2207 | 4 | | Anne | 1900 | 5 | +----------+-----------+--------+ SELECT User, Score, @curRank := @curRank + 1 AS Rank FROM Rankings p, (SELECT @curRank := 0) r ORDER BY Score DESC;Hi Arturo,
Thank you for your purchase.
Sorry for late response. We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Sorry to disappoint you but unfortunately variables in mysql queries are not supported.
But you can use placeholders.
You can take a look at our documentation about placeholders here.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi,
Can you explain me how to do that?
The documentation doesn't explain how can i do that :/
At least see an auto incremental number on every row
1 - Row 1
2 - Row 2
3 - Row 3
Hi Arturo,
Placeholders can be understood as predefined “search and replace” templates that will be replaced with some actual values at the execution time.
My suggestion is to look up this ticket and try to do that with "SET" and then make a "VIEW" from that table.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi,
That ticket is private, I can't see the content
Thanks for your time!
Hi Arturo,
Sorry about that. Here you can see the part of the ticket that can be useful for you.
Netflair
Hi Milan,
i didnt know i could create a VIEW in phpmyadmin. This information really made my day.
It works perfectly now, thank you very much for your time and help.
You
Hi Patrick,
Whan you are using complicated SQL queries, my suggestion is to make a VIEW in phpmyadmin and see if that query returns the desired result. If the result is good , use that query
SELECT * FROM view_name
as an input when creating the tables with Add from data source option.
Netflair replied
Hi Milan,
thank you for your help so far. I got one more Error: SET not implemented.
Is there a way to implement it ? I am trying to use SET SQL_BIG_SELECTS=1; It works fine within PHPMyAdmin.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables