Custom query not returning results when using parameters

Hi,

Here is my custom query where I populated the Select statement with the required values. You will see I get a query result returned.

However, when I use parameters, I get no query result.


Why would the query fail to return results when using parameters?

The database is MS SQL.

Thanks,
Ray

And what are the test values of the parameters you entered to be used to run the custom query?

Hi George ,

The values I passed in the first screen shot are listed in the parameter test value columns in the second screen shot.

They are the same values for both queries.

Thanks
Ray

@George Sorry, I was driving at the time.

:P1 = IbeccK._tk8*UbL:^GH/%P8uC
:P2 = Camera192Q3

Regards,
Ray

Are you sure those records exist in the development database you are using on this target?

@George, Iā€™m not changing the target or leaving the custom query screen.

So if I am getting the record when directly providing the values, I would presume I would also get the record when using parameters.

Thanks,
Ray

Are you sure your password is coming through from $_POST not $_GET?

Hi @Heather_Mann

There is no need to use POST or GET when using test values and executing it from within the query window.

Thanks
Ray.

@George I have even tried to reduce from two parameters to one so that I can be sure that the + operation was not causing some strange result, but this has made no difference.

Replicating the original query in MS SQL using the two parameters will retrieve a record.

Thanks, Ray.

1 Like

Hi @George ,

Just wondering if you had a chance to look into this any further.

Thanks
Ray