Fabbstar

YOU DID IT!!! AMAZING.

Thanks John.

Make it a default feature, great thing!

Simon

Hi John,

Unfortunately, having saved over the original JS file with the GIS code you provided, it doesn’t seem to filer by the URL.

Try:

http://www.simonlyplans.com/sim-only-deals/?jtrt_dt_search=o2

You’ll see it doesn’t filter the table by “o2”.

Thanks,
Simon

Hi Michael,

Thanks for the reply.

Will the result of your suggestion be a URL that could in theory be amended by the user to expose the rest of the data in the table?

That’s what I’m trying to avoid by using my SQL approach to generate a different URL structure that can’t be tampered with.

Thanks,
S

Hi Michael,

Thanks for that. I’ve already taken up a lot of your time, but I’ll show you what I have in place which still returns nothing, as opposed to zero.

Function code:

require_once(ABSPATH . 'wp-content/plugins/contact-form-7-to-database-extension/CFDBPermittedFunctions.php');
function parse_form_money($value) {
return floatval(preg_replace('([^0-9.])', '', $value));
}
cfdb_register_function('parse_form_money');
function zero_if_null($x) {
    return is_null($x) ? 0 : $x;
}
cfdb_register_function('zero_if_null');

Shortcode:

[cfdb-value tfilter=”Customer=$user_login&&Status=Completed” trans=”Value=parse_form_money(Value)&&SumField(Value)&&Value=number_format(Value,2)&&Value=concat(£,Value)&&Value=zero_if_null(Value)” form=”FORM NAME” show=”Value”]

Maybe I am being silly and have missed something?

Thanks again,
S

• This reply was modified 9 years, 7 months ago by Fabbstar.

Hi,

Thanks so much for trying it out, at least I know it works!

I am using SQL due to the requirements of a plugin which allows me to use a text field to pull in data from the WP database using SQL.

Still can’t get it to work though, I’ll have to see if the plugin author can explain why.

Thanks again,
S