We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
So I looked at the documentation but cannot find what I a looking for. I used placeholders to make things work a bit better for me, but I am running into some issues and wonder if I am not making a mistake.
I made a query:
SELECT '%VAR1%', price_usd * (SELECT exchange_rate FROM jgd_exchangerate WHERE exchange_rate_id = '%VAR2%') FROM jgd_prices WHERE price_id='%VAR3%'
Which works fine if I use the values instead of the placeholders.
I predefined values for all the three VAR's
If I use the short code without setting any parameters it kind of works, but if I use variables it does not work, it throws out an php error.
It seems that if I want to use a placeholder before the FROM statement those placeholders don't work, if I use them after the FROM statement no problems.
How can this be fixed?
Thank You in advance for your answer
Jan
Hi Jan,
Thank you for your purchase.
Unfortunately at the moment it is not possible to use placeholders after SELECT statement. Placeholders are
intended to use in WHERE clause in query.
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