Announcement

Collapse
No announcement yet.

Passing a parameter to a stored procedure no working

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Passing a parameter to a stored procedure no working

    Using SCv6 6.00.018

    I have a grid with the following SQL.

    The SELECT
    OBJ_GUID, PST_STS, MIN_LFT, PAY_MTHD, IS_ADLT, PLUS_PNTS, HAVE, NEED, NAME, CONTACT_INFO, PST_SEQ
    FROM
    PRC_SCANNER( '[usr_obj_guid]', 0)
    ORDER BY MIN_LFT DESC

    The global variable, which works in all other places in SCv6, is not interpreted as a global variable in this case. Instead, it is left as a literal and characters are both prepended and appended to it.. so in the php file, I end up with the non-functional SQL statement:

    The SELECT
    OBJ_GUID, PST_STS, MIN_LFT, PAY_MTHD, IS_ADLT, PLUS_PNTS, HAVE, NEED, NAME, CONTACT_INFO, PST_SEQ
    FROM
    PRC_SCANNER( '" . $_SESSION['usr_obj_guid'] . "', 0)
    ORDER BY MIN_LFT DESC

    What is the syntax for preventing the character replacement, and inserting the actual guid (Like '7787-9909-0090')? Or, is this a bug?

  • #2
    Hello Boxer,

    Are you still facing this issue?

    regards,
    Bernhard Bernsman

    Comment

    Working...
    X