I try to implement SQL adopter using WHERE - IN clause and caught an error.
The parameter length will varies each invocation.
FWLSE0099E: An error occurred while invoking procedure SmanabAPI/SqlStatement
"preparedStatement": "SELECT * FROM TABLE WHERE KEY IN (?,?)"
The preparedStatement was not created properly as a prepared statement.
FWLSE0101E: Caused by: null
Is there a sample for WHERE - IN statement ?
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
3 replies Latest Post - 2013-02-08T00:25:41Z by SystemAdmin
Pinned topic SELECT - WHERE - IN clause
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
pandrbox 120000EG3V22 PostsACCEPTED ANSWER
Re: SELECT - WHERE - IN clause2013-02-01T13:45:35Z in response to pandrboxI was aware of this is difficult to implement on Worklight. The length of LIST for IN is variable. Because createStatement has to be executed out side of function.
SystemAdmin 110000D4XK2327 PostsACCEPTED ANSWER
Re: SELECT - WHERE - IN clause2013-02-08T00:25:41Z in response to pandrboxNote: IBM forums are in the process of migrating to a new format. During migration the forums will be frozen and in read-only mode. If you wish to continue this thread discussion please post it on stackoverflow, where the Worklight team and others can respond.
See the Forum Migration announce post for more details. Thank you.
Barbara Hampson, Manager, IBM Worklight