Allow Special characters in User Parameters

(3 posts) (2 voices)

Tags:

No tags yet.

  1. biceda, Member

    Hi,

    Is it possible to allow some special characters in the User Parameter input fields?
    I understand limiting to Text only to reduce SQL injection issues.

    I'm trying to pass an Item code into a select statement that has "-" in it. eg Item code "100-075-AA00"

    It works in report filters, but fails on User Parameter input fields.

    Thanks.

    Posted 2 months ago #
  2. myDBR Team, Key Master

    Hi,
    there are no limitations on characters in the user parameters. Could you elaborate what your report parameters looks like and the problem you are facing. Do you get an error message or what is the problem?

    --
    myDBR Team

    Posted 2 months ago #
  3. biceda, Member

    Hi,

    Sorry, fixed issue. Simple mistake, my SQL statement didn't have the User Parameter enclosed in quotes.

    Thanks,
    Darryl.

    Posted 1 month ago #

Reply

You must log in to post.