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: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<body bgcolor="#ffffff" text="#000000">
Hello Arun,<br>
Arun ViswanathanChandrika schrieb:
  <p><font size="2"><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>
Resolves to: <font size="2">SELECT EMP_NAME FROM EMP where EMP_ID IN
Watch the "'"'s :)<br>
With best regards,<br>
Daniel Migowski</font>

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-2017 The PostgreSQL Global Development Group