Parameter use, error: FUNCTION mpay.$P does not exist

[haskins.aaron]

Hi, I am trying to use a parameter for a report but I am seeing this error return:

FUNCTION mpay.$P does not exist

mpay is the name of the database. We are using MariaDB if that helps.

The dataset is a really basic SQL query (trying to remove all complication):

select * from transactionmemo where da_holder = $P(da_holder)[/code]

I have created a parameter called da_holder. If I removed the parameter and hardcode this it works, but it doesn't seem to like the parameter use. I cannot understand where this error comes from, please help! I am using TIBCO Jaspersoft Studio.

[haskins.aaron]

Ignore me. Using the wrong brackets, ARGH.

[hozawa]

$P(da_holder) $should have been $P{da_holder}