Skip navigation
gchammer
Currently Being Moderated

How Do I use a variable for a datasource

Jul 2, 2013 11:23 AM

Tags: #adobe #livecycle #variable #datasource #data_connection

I'm trying to use a variable as a datasource so changes are easy to make with out having to look through the entire process.

If I use SLC_ENGFC_DEV_DS as the literal value the select statement it works. If I create a string variable and set the default value to the same thing I get the error

Exception: Invalid object name 'FLUDDEPT'.

 
Replies
  • Currently Being Moderated
    Jul 2, 2013 8:52 PM   in reply to gchammer

    Here is how I do this :

     

    jdbcTest.jpg                               dataSRC.jpg

     

    Thanks,

    Wasil

     
    |
    Mark as:
  • Currently Being Moderated
    Jul 3, 2013 9:54 PM   in reply to gchammer

    OK !

     

    I assume you are using sql server, use the query like this :

     

    select * from [database].[schema].[tablename];

     

    Make sure the user (mentioned in Jboss datasource has access(to the database) as well as the required permissions (select, delete etc) for the table object.

     

    e.g.

     

    sqlQuery.jpg

     

    Thanks,

    Wasil

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points