Return-Path: 
 <user-java-return-6488-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 33423 invoked from network); 23 Mar 2006 08:38:05 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 23 Mar 2006 08:38:05 -0000
Received: (qmail 34136 invoked by uid 500); 23 Mar 2006 08:38:03 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 34101 invoked by uid 500); 23 Mar 2006 08:38:02 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 34088 invoked by uid 99); 23 Mar 2006 08:38:02 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Mar 2006 00:38:02 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS,UPPERCASE_25_50
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of gnomeking@gmail.com designates
 64.233.182.186 as permitted sender)
Received: from [64.233.182.186] (HELO nproxy.gmail.com) (64.233.182.186)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Mar 2006 00:38:01 -0800
Received: by nproxy.gmail.com with SMTP id a25so273194nfc
        for <user-java@ibatis.apache.org>;
 Thu, 23 Mar 2006 00:37:40 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=AsELweP2bPPJjUDrnKajrvRknvYqIpyd1xIAIg/aRJT90F3wJ/ElBIpacg2bhN8g+q2MxcEAFtF8nkuB/4UVQnfdA1sQXYgjvUJAk8Xzn+C3qo8WZI9x1wSj7uVMy5JxLnhV/qt+E8UB3LLk8aPU9LKu9rFQ9kN3P58Z1ea8kVg=
Received: by 10.48.220.16 with SMTP id s16mr463126nfg;
        Thu, 23 Mar 2006 00:37:40 -0800 (PST)
Received: by 10.48.255.15 with HTTP; Thu, 23 Mar 2006 00:37:39 -0800 (PST)
Message-ID: <d990bcc80603230037n1c47d96bu@mail.gmail.com>
Date: Thu, 23 Mar 2006 08:37:40 +0000
From: Bob <gnomeking@gmail.com>
To: user-java@ibatis.apache.org, lmeadors@apache.org
Subject: Re: sql server 2k parameterized queries
In-Reply-To: <a10a823c0603221951m6f69fa3ck853160df481b0d80@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <d990bcc80603221719i3cf29d1es@mail.gmail.com>
	 <a10a823c0603221951m6f69fa3ck853160df481b0d80@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

On 23/03/06, Larry Meadors <lmeadors@apache.org> wrote:
> Can you post the mapped statement?

Certainly - but it is very simple!

=09<statement id=3D"getPayoutOrgData" resultClass=3D"java.util.HashMap">
=09=09SELECT EVENT.EVENTCD,
=09=09=09sum(WTRANS.NETSTAMT) AS NET_VALUE
=09=09FROM WTRANS
=09=09=09INNER JOIN EVENT
=09=09=09=09ON WTRANS.EVENTCD =3D EVENT.EVENTCD
=09=09WHERE WTRANS.TRX_TYPE=3D'S'
=09=09=09AND WTRANS.[FUNCTION]=3D1
=09=09=09AND #shows#
=09=09GROUP BY EVENT.EVENTCD, EVENT.NAME
=09=09ORDER BY EVENT.NAME
=09</statement>

I am querying with:

        Map filters =3D new HashMap();
        filters.put("shows", shows);
        List ret =3D getSqlMap().queryForList(
                    "getPayoutOrgData",
                    filters);

shows is a string of the following format: (it is dynamically created
and can be quite long, but the example which is falling over has just
one entry)
(WTRANS.EVENTCD=3D"ABC" OR WTRANS.EVENTCD=3D"DEF")

... thinking about it, is that the problem? Can I use a parameterized
statement when an entire where clause is dynamically generated?

Bob