Announcement

Collapse
No announcement yet.

pdf not presenting option for parameters...

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

  • pdf not presenting option for parameters...

    Hey folks

    Have a pdf file which am trying to link to a form via a button, when creating the link between the two the form is not presenting any option for parameter selection.

    here is my pdf sql created with the sql builder:
    SELECT
    club.clubLogo,
    club.clubName,
    club.clubTell,
    club.clubMobile,
    club.clubEmail,
    mbr.mbrFname,
    mbr.mbrLname,
    mbr.mbrPhoto,
    mbr.mbrDateValid
    FROM
    club,
    mbr
    WHERE
    (mbr.mbrID = '{mbrID}') AND
    (club.clubID = '1')

    any help would be aprechiated..... thx in advance

  • #2
    any comments on this or do I need to open a ticket?

    Should be something simple I would imagine, just everything I have tried so far is not presenting me any options for parameters so sending a user from a form to the pdf is turning up empty... HELP!

    Comment


    • #3
      just to note.. have opened a ticket the other day for this as I still am unable to retrieve any data....
      Hoping to have a reply some time soon, been 2 days already since ticket was opened........

      Comment


      • #4
        thought I would add the result to this one, so eventually got a reply from support to my urgent ticket after a few days......

        solution is that local variables do not work, they have to be global variables.

        create a variable name, in my case was simple:

        Scriptinit -
        sc_reset_global ([mbrID]);

        Then set the global variable following the kill above

        $my_var = {mbrID};
        sc_set_global($my_var);

        {mbrID} = the form field which is what I wanted to capture providing me with the member ID

        then with the button link to the PDF which I already had created.
        Within the SQL statement add a WHERE clause, note local {} variabled so not pass to other forms unless master detail!

        so SQL:
        WHERE
        mbrID = '[mbrID]'

        and thats it all working

        Comment


        • #5
          grrr had this working for a moment now the global variable isnt sticking.....

          any ideas?

          Comment

          Working...
          X