/scripts/ahub.form.attachments.js
0

JDBC Lookup error

Oct 24, 2016 at 11:59 PM

39

avatar image

Hi Expert

I am using the JDBC lookup in my scenario , In my table 3 columns -BusinessUnitEntityKey,SKUIdentifier,RnSKUEntityKey, I want to pick the data based on BusinessUnitEntityKey,

Like:SELECT "SKUIdentifier", "RnSKUEntityKey" FROM "SAP_RNA_SKUS" WHERE BusinessUnitEntityKey= "9011"," 101"

once i run my lookup is is showing error : Cause Exception: 'Error processing request in sax parser: Error when executing statement for table/stored proc. 'table' (structure 'statement'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '='.'.

it is not picking multiple recoreds at a time .

please help me for this issue .

Regards

pankaj Singh



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Harish Mistri Oct 25, 2016 at 02:50 AM
0

Hi Pankaj,

AFAIK - you do not need double quote ("") in table and column name in select query. change your query as

SELECT SKUIdentifier, RnSKUEntityKey FROM SAP_RNA_SKUS WHERE BusinessUnitEntityKey= "9011"," 101"

and refer the below link

http://www.w3schools.com/sql/sql_select.asp

regards,

Harish

Share
10 |10000 characters needed characters left characters exceeded
Skip to Content