Return-Path: 
 <user-return-4646-apmail-cayenne-user-archive=cayenne.apache.org@cayenne.apache.org>
Delivered-To: apmail-cayenne-user-archive@www.apache.org
Received: (qmail 73427 invoked from network); 11 Sep 2008 15:54:31 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 11 Sep 2008 15:54:31 -0000
Received: (qmail 9164 invoked by uid 500); 11 Sep 2008 15:54:10 -0000
Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org
Received: (qmail 9090 invoked by uid 500); 11 Sep 2008 15:54:10 -0000
Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cayenne.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cayenne.apache.org>
List-Post: <mailto:user@cayenne.apache.org>
List-Id: <user.cayenne.apache.org>
Reply-To: user@cayenne.apache.org
Delivered-To: mailing list user@cayenne.apache.org
Received: (qmail 9058 invoked by uid 99); 11 Sep 2008 15:54:10 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Sep 2008 08:54:10 -0700
X-ASF-Spam-Status: No, hits=1.2 required=10.0
	tests=SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Received: from [88.191.42.248] (HELO genux) (88.191.42.248)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Sep 2008 15:53:11 +0000
Received: from [200.190.12.96] (unknown [212.51.168.10])
	by genux (Postfix) with ESMTP id 0385D4C1F5
	for <user@cayenne.apache.org>; Thu, 11 Sep 2008 17:53:44 +0200 (CEST)
Message-ID: <48C93EE3.6020905@smaeur.com>
Date: Thu, 11 Sep 2008 17:53:07 +0200
From: Laurent Marchal <lmarchal@smaeur.com>
User-Agent: Thunderbird 2.0.0.16 (X11/20080724)
MIME-Version: 1.0
To: user@cayenne.apache.org
Subject: Returning updated rows from SQLTemplate
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Hello !

I use Cayenne 3.0M4 and since UpdateQuery is deprecated i use a 
SQLTemplate query to do an UPDATE.
The thing is i would like to know how many rows are updated, and the 
query returns no DataRows.

SQLTemplate query = new SQLTemplate(..., "UPDATE...");
query.setFetchingDataRows(true);

List<DataRow> dtList = context.performQuery(query);

the returned list is always empty....
How can i get the precious Integer saying "X rows updated" ?

Thanks.
Laurent Marchal.