Re: issue with select IN (?) query

From: Daniel Migowski <dmigowski(at)ikoffice(dot)de>
To: Arun ViswanathanChandrika <Arun(dot)ViswanathanChandrika(at)ust-global(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: issue with select IN (?) query
Date: 2008-07-22 06:54:49
Message-ID: 48858439.3020101@ikoffice.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hello Arun,<br>
<br>
Arun ViswanathanChandrika schrieb:
<blockquote
cite="mid:4ADAE57BEACCF2489D5871A8B883F9DD16EE27(at)TRVMSG(dot)ustr(dot)com"
type="cite">
<p><font size="2"><br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pm = con.prepareStatement("SELECT EMP_NAME FROM EMP where
EMP_ID IN (?) ");<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pm.setString(1, "2,5,7");&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //created many employees and
id with 2, 5 and 7<br>
</font></p>
</blockquote>
Resolves to: <font size="2">SELECT EMP_NAME FROM EMP where EMP_ID IN
('2,5,7');<br>
<br>
Watch the "'"'s :)<br>
<br>
With best regards,<br>
Daniel Migowski</font>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 875 bytes

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message David Rees 2008-07-23 20:00:40 Timestamp Problems
Previous Message Arun ViswanathanChandrika 2008-07-20 13:39:28 issue with select IN (?) query