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 ?
This topic has been locked.
Pinned topic SELECT - WHERE - IN clause
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
pandrbox 120000EG3V22 Posts
Re: SELECT - WHERE - IN clause2013-02-01T13:45:35ZThis is the accepted answer. This is the accepted answer.I 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.
IdanAdar 2700059KWB741 Posts
Re: SELECT - WHERE - IN clause2013-02-03T05:33:22ZThis is the accepted answer. This is the accepted answer.pandrbox,
Do you mean by your second message that you have solved your issue, or is this still an open issue for you?
IBM Worklight Mobile Platform
SystemAdmin 110000D4XK2327 Posts
Re: SELECT - WHERE - IN clause2013-02-08T00:25:41ZThis is the accepted answer. This is the accepted answer.
- pandrbox 120000EG3V
See the Forum Migration announce post for more details. Thank you.
Barbara Hampson, Manager, IBM Worklight