RE: Count of number of rows returned in delete / update sql in Perl DBI ?

2008-07-10 Thread Ow Mun Heng
$del_rows = 0; } -Original Message- From: Amit Saxena [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2008 7:45 PM To: Perl Beginners Subject: Count of number of rows returned in delete / update sql in Perl DBI ? Hi all, I want to know how to get the count of number of r

Re: Count of number of rows returned in delete / update sql in Perl DBI ?

2008-07-10 Thread Amit Saxena
the query. Regards, Amit Saxena On Thu, Jul 10, 2008 at 8:12 PM, Rob Dixon <[EMAIL PROTECTED]> wrote: > > Amit Saxena wrote: > > Hi all, > > > > I want to know how to get the count of number of rows returned in delete > / > > update sql in Perl DBI ? >

Re: Count of number of rows returned in delete / update sql in Perl DBI ?

2008-07-10 Thread Rob Dixon
Amit Saxena wrote: > Hi all, > > I want to know how to get the count of number of rows returned in delete / > update sql in Perl DBI ? > > I have ready some articles on the internet and it states that the "execute" > function returns the number of rows affect

Re: Count of number of rows returned in delete / update sql in Perl DBI ?

2008-07-10 Thread yitzle
On Thu, Jul 10, 2008 at 7:44 AM, Amit Saxena <[EMAIL PROTECTED]> wrote: > Hi all, > > I want to know how to get the count of number of rows returned in delete / > update sql in Perl DBI ? > > I have ready some articles on the internet and it states that the "execute&q

Count of number of rows returned in delete / update sql in Perl DBI ?

2008-07-10 Thread Amit Saxena
Hi all, I want to know how to get the count of number of rows returned in delete / update sql in Perl DBI ? I have ready some articles on the internet and it states that the "execute" function returns the number of rows affected though it's not confirmed to work for all the data

Re: sql in perl

2001-12-30 Thread Simon K. Chan
Hi Nafiseh, I'm not fully sure I understand your question. However, I think you are asking how to display the data that is returned in a certain form (sort?). If so, read on. Are you using the Database Interface (DBI) Module? If so, Answer to 1: Not entirely sureCheck a SQL tutorial s

sql in perl

2001-12-30 Thread nafiseh saberi
hi dear team... how r u ? 1-how can I delete one column in table that build in postgres ?? (there is not parameter in ALTER) 2-how can I sort the column of table in form of that I want?? thx. __ Sincerely yours Nafiseh Saberi People will forget what you said