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

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

    Re: SELECT - WHERE - IN clause

    ‏2013-02-01T13:45:35Z  
    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
    IdanAdar
    741 Posts

    Re: SELECT - WHERE - IN clause

    ‏2013-02-03T05:33:22Z  
    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
  • SystemAdmin
    SystemAdmin
    2327 Posts

    Re: SELECT - WHERE - IN clause

    ‏2013-02-08T00:25:41Z  
    • pandrbox
    • ‏2013-02-01T13:45:35Z
    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.
    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