Hey everyone!
With the holiday season upon us, we want to share our upcoming working hours:
- New Year: Our team will be off on January 1st and 2nd. We’ll be back on Friday, January 3rd, to respond to any messages received during this time.
- Weekend: As usual, we don’t work on weekends, so January 4th and 5th will also be non-working days.
- Orthodox Christmas: Our office will be closed on Monday and Tuesday, January 6th and 7th for the holiday.
After that, we’ll return to our regular schedule and assist you as quickly as possible.
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.
Thanks a bunch for your understanding and support!
Warm regards and happy holidays!
TMS
I am trying to add a parameter to a MySQL query using the placeholder %VAR1%. Per the following directions on https://wpdatatables.com/documentation/table-features/using-placeholders/
"If you are using String for Placeholder ‘variable’ %VAR1% should be surrounded with Single Quote (‘)."
So in my query I added single quotes to the placeholder reference as such: '%VAR1%'. Unfortunately, the query fails. It works fine with numeric data.
Please advise.
Hi Mark,
Thank you for your purchase.
Can you please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the page where you have this issue so I can take a look.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
I have managed to resolve this issue.
Thank you for your help.
Hi Mark,
Glad that you solved the issue.
You are welcome.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
I had same problem and resolved by myself.
The document is not very clear, particularly this line below.
If you are using String for Placeholder ‘variable’ %VAR1% should be surrounded with Single Quote (‘) in the query.
I think the document can be improved by giving an example, for example:
SELECT * FROM users WHERE email = '%VAR1%';
@ Mark Lee:
Could you please share how you resolved this?
I'm facing the same issue… and would appriciate it.
Thx.
Not sure if what I did will help you. I actually did away with the single quotes.
WHERE Custid = '%VAR1%'
becomes
WHERE Custid = %VAR1%
Thx for your reply…
I found out through this site that the SELECT function from the SQL query is NOT supported. The FROM and WHERE statements ARE supported. Unfortunately I started with the SELECT statement and could not get it to work. (still can't). But using just FROM and WHERE got me what I need.
Again thx for taking the time to reply.