Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 55719 invoked from network); 21 Jun 2006 05:59:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 21 Jun 2006 05:59:36 -0000 Received: (qmail 32918 invoked by uid 500); 21 Jun 2006 05:59:30 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 32899 invoked by uid 500); 21 Jun 2006 05:59:30 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 32888 invoked by uid 99); 21 Jun 2006 05:59:30 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Jun 2006 22:59:30 -0700 X-ASF-Spam-Status: No, hits=1.9 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [202.43.219.156] (HELO web8408.mail.in.yahoo.com) (202.43.219.156) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 20 Jun 2006 22:59:28 -0700 Received: (qmail 87383 invoked by uid 60001); 21 Jun 2006 05:59:05 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=gS0ZOj/o8dKNU3FiVsbzNlkFaMrzVE4wF0NUIiIVjAp/DUhDft+CerYRsZznLbOEztx6l5/GvS5lZlE5ZTlxDCBVtkU1gLkXe2RyAm/N1IVWXpP9t23eja1CqD+DEz+tRfd7YVw3+Q+cdEakBbub4xFOeF6/eoIlV3i+EHiSayw= ; Message-ID: <20060621055905.87381.qmail@web8408.mail.in.yahoo.com> Received: from [210.211.198.203] by web8408.mail.in.yahoo.com via HTTP; Wed, 21 Jun 2006 06:59:05 BST Date: Wed, 21 Jun 2006 06:59:05 +0100 (BST) From: puneet arya Subject: how to use IN CLAUSE To: user-java@ibatis.apache.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-798607857-1150869545=:85221" Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --0-798607857-1150869545=:85221 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, How to use IN CLAUSE in a stored procedure . i want to pass multiple values through IN CLAUSE in stored procedure. so how to pass it like select * from tablename where column name in (comma separated values). if any body know the solution plz tell its urgent. Puneet Arya --------------------------------- Yahoo! India Answers: Share what you know. Learn something new Click here Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download now --0-798607857-1150869545=:85221 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit

Hi,

How to use IN CLAUSE in a stored procedure . i want to pass multiple values through IN CLAUSE in stored procedure.

so how to pass it like select * from tablename where column name in (comma separated values).

if any body know the solution plz tell its urgent.

Puneet Arya

Yahoo! India Answers: Share what you know. Learn something new Click here
Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download now --0-798607857-1150869545=:85221--