Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 20FAD475A98 for ; Thu, 20 Jun 2002 00:00:18 -0400 (EDT) Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2]) by postgresql.org (Postfix) with ESMTP id 67E10475A7D for ; Thu, 20 Jun 2002 00:00:15 -0400 (EDT) Received: from oasis.net.au (guardian [210.8.139.5]) by water.oasis.net.au (8.9.3/100.1) with ESMTP id OAA29983 for ; Thu, 20 Jun 2002 14:09:43 +1000 X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5] claimed to be oasis.net.au Message-ID: <3D11539F.6020401@oasis.net.au> Date: Thu, 20 Jun 2002 14:01:35 +1000 From: Rudi Starcevic User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.0rc2) Gecko/20020510 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Rows affected Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200206/264 X-Sequence-Number: 8229 Hello friends, We're using Postgresql with PHP, Perl and ColdFusion for web development. With PHP and Perl we have functions to find out the number of rows affected by an insert /update/ delete. I'm wondering if anyone has experience getting the affected row count with ColdFusion. For example in PHP we have the pg_cmdtuples function. Perhaps there's and sql or built in Pg function I can call from a query/sql statement. Your advice is greatly appreciated. Thanks Best regards Rudi Starcevic.