Forum Discussion

cstott1's avatar
cstott1
Occasional Contributor
9 years ago

Unable to transfer data from a data source into SQL query

I'm trying to transfer data from a data source to be used in a where statement of a SQL query. Essentially my script does the following:   Holds “ID” numbers in a grid data source Executes a SOAP...
JDBC
sql
cstott1's avatar
cstott1
Occasional Contributor
9 years ago

Hi Nmrao

 

Thanks for the feedback, I have tried putting a property transfer step in before the JDBC step to bring the field i want to use from the SOAP response into the parameter

 

when I run it the value is passed into parameters table however when I try to use it in my SQL it does not recognise it - below message is displayed

 

  • 2016-02-24 11:44:55 - Error getting response; java.lang.IllegalArgumentException: Parameter 'Tracking' was not found in the SQL Query.

the parameter is called Tracking and my sql is below - is the way i'm referring the parameter incorrect?

 

Select *
From opscontrol.piece
Where opscontrol.piece.TrackingNumber = 'Tracking'

 

(note in my initial request ID is the same as tracking - i called it ID for ease of reference)

 

i've added some screen shots - any help would be greatly appreciated

  • cstott1's avatar
    cstott1
    Occasional Contributor
    9 years ago

    Just found it needs to be - then it works.... :-)

     

    Select *
    From opscontrol.piece
    Where opscontrol.piece.TrackingNumber = :Tracking

    • nmrao's avatar
      nmrao
      Champion Level 3
      9 years ago
      Actually it seems to be some problem in displaying a colon and then p (in my last reply). Any ways, glad to know.