pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRows affected
2+ messages / 2 participants
[nested] [flat]
* Rows affected
@ 2002-06-20 04:01 Rudi Starcevic <rudi@oasis.net.au>
0 siblings, 1 reply; 2+ messages in thread
From: Rudi Starcevic @ 2002-06-20 04:01 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Rows affected
@ 2002-06-20 07:25 Gaetano Mendola <mendola@bigfoot.com>
parent: Rudi Starcevic <rudi@oasis.net.au>
0 siblings, 0 replies; 2+ messages in thread
From: Gaetano Mendola @ 2002-06-20 07:25 UTC (permalink / raw)
To: Rudi Starcevic <rudi@oasis.net.au>; pgsql-sql
Try after your operation:
GET DIAGNOSTICS my_rows = ROW_COUNT;
----- Original Message -----
From: "Rudi Starcevic" <rudi@oasis.net.au>
To: <pgsql-sql@postgresql.org>
Sent: Thursday, June 20, 2002 6:01 AM
Subject: [SQL] Rows affected
> 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-06-20 07:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-06-20 04:01 Rows affected Rudi Starcevic <rudi@oasis.net.au>
2002-06-20 07:25 ` Gaetano Mendola <mendola@bigfoot.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox