Topic
3 replies Latest Post - ‏2013-02-08T00:25:41Z by SystemAdmin
pandrbox
pandrbox
22 Posts
ACCEPTED ANSWER

Pinned topic SELECT - WHERE - IN clause

‏2013-01-31T05:36:04Z |
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
FWLSE0100E: parameters:{
"arr": [
{
"parameters": [
"key1",
"key2"
],
"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 ?
  • pandrbox
    pandrbox
    22 Posts
    ACCEPTED ANSWER

    Re: SELECT - WHERE - IN clause

    ‏2013-02-01T13:45:35Z  in response to pandrbox
    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.
    • SystemAdmin
      SystemAdmin
      2327 Posts
      ACCEPTED ANSWER

      Re: SELECT - WHERE - IN clause

      ‏2013-02-08T00:25:41Z  in response to pandrbox
      Note: 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
  • IdanAdar
    IdanAdar
    741 Posts
    ACCEPTED ANSWER

    Re: SELECT - WHERE - IN clause

    ‏2013-02-03T05:33:22Z  in response to pandrbox
    pandrbox,
    Do you mean by your second message that you have solved your issue, or is this still an open issue for you?

    Idan Adar
    QA Engineer
    IBM Worklight Mobile Platform