Copyright 2019 - Schultz IT Solutions - swiss servicequality for austrian and international enterprises - All rights reserved.

Getting a 47501 syntax error

  • Sean Kelley
  • Topic Author
More
16 Jul 2019 19:11 #1 by Sean Kelley
Replied by Sean Kelley on topic Getting a 47501 syntax error
Aha, of course! The single quote. The easiest fix in this case was to simply remove the quote and rename everything from "St. John's" to "St. Johns".

Thanks for your help!

Please Log in or Create an account to join the conversation.

  • Rüdiger Schultz
  • Rüdiger Schultz's Avatar
More
16 Jul 2019 14:03 #2 by Rüdiger Schultz
Replied by Rüdiger Schultz on topic Getting a 47501 syntax error
From the look at it, we are dealing with a "single quote" issue here...

"FL: Jacksonville (St. John's Town Center)"

But I think there might be a misunderstanding in the usage of these runtime parameters (maybe I am wrong):

It might be better, if you use any kind of ID (for the location) rather than the "Name" in order to create your WHERE clause in the SQL...

So your runtime parameter query should look something like this:

Select concat("ID: ", id) as PARAMKEY, id as PARAMVALUE from #__categories

This would create a "list of values", where the selected value would be the ID only (which you could use in your worksheet SQL).

Ruediger Schultz
Schultz IT Solutions

Please support jDBexport on JOOMLA Extension directory (JED) at
extensions.joomla.org/extensions/extensi...ta-reports/jdbexport

Please Log in or Create an account to join the conversation.

  • Sean Kelley
  • Topic Author
More
14 Jul 2019 16:27 #3 by Sean Kelley
Getting a 47501 syntax error was created by Sean Kelley
A few months ago I purchased and set up jDBexport on my site at www.mission-bbq.com . I used it to create a simple tool that allows us to export db records (in this case coming from forms) as CSV files.

You can see the tool here - www.mission-bbq.com/form-export

I've set up a runtime parameter that lets the user select which "Location" they want to filter by. And that has worked perfectly until recently.

A user indicated to me that when they try to filter using one specific location -- "FL: Jacksonville (St John's Town Center)" -- they are getting a 47501 error. However filtering by any other location works fine.

Can you provide any advice on how to correct this issue?

Please Log in or Create an account to join the conversation.