Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: unknown_filename
Description: text/html (875 bytes)

In response to

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group