Postgres Pro
Downloads
Home   >   mailing lists

Re: issue with select IN (?) query - Mailing list pgsql-jdbc

From Daniel Migowski
Subject Re: issue with select IN (?) query
Date
Msg-id 48858439.3020101@ikoffice.de
Whole thread Raw
In response to issue with select IN (?) query  ("Arun ViswanathanChandrika" <Arun.ViswanathanChandrika@ust-global.com>)
List pgsql-jdbc
Tree view 
Hello Arun,<br /><br /> Arun ViswanathanChandrika schrieb: <blockquote
cite="mid:4ADAE57BEACCF2489D5871A8B883F9DD16EE27@TRVMSG.ustr.com"type="cite"><p><font size="2"><br /><br />         pm
=con.prepareStatement("SELECT EMP_NAME FROM EMP where EMP_ID IN (?) ");<br />         pm.setString(1, "2,5,7");       
//createdmany employees and id with 2, 5 and 7<br /></font></blockquote> Resolves to: <font size="2">SELECT EMP_NAME
FROMEMP where EMP_ID IN ('2,5,7');<br /><br /> Watch the "'"'s :)<br /><br /> With best regards,<br /> Daniel
Migowski</font>

pgsql-jdbc by date:

Previous
From: "Arun ViswanathanChandrika"
Date:
Subject: issue with select IN (?) query
Next
From: "David Rees"
Date:
Subject: Timestamp Problems