Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 22 Jul 2008 08:54:49 +0200
- Message-id: <48858439.3020101@ikoffice.de> <text/plain>
<!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>
pm = con.prepareStatement("SELECT EMP_NAME FROM EMP where
EMP_ID IN (?) ");<br>
pm.setString(1, "2,5,7"); //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>
- References:
- issue with select IN (?) query
- From: Arun ViswanathanChandrika
- issue with select IN (?) query
- Prev by Date: issue with select IN (?) query
- Next by Date: Timestamp Problems
- Previous by thread: issue with select IN (?) query
- Next by thread: Timestamp Problems
- Indexes: