RE: example of placeholders

2003-06-17 Thread Dan Muey
> > $sth->execute($dbh->selectrow_array('select distinct > tableowner from > > pg_tables')); > > The selectrow_array() method returns only the first row from > the inner query. Oh yeah, duh, sorry about that, It was a Classic Monday yesterday and it still is today! Sorry for giving you bad in

RE: example of placeholders

2003-06-17 Thread Bob Showalter
Johnson, Shaunn wrote: > --howdy. > > --i think i am getting closer to solving this, but > --i have ran into a problem. > > --the below program works to the point where it > --will return the data, but not ALL of the data. > > --for example, i get only about 50 or so lines when > --if i do the q

Re: example of placeholders

2003-06-17 Thread John W. Krahn
Shaunn Johnson wrote: > > --howdy. Hello, > [snip] > > my $list="userlist.txt"; > my $file="newlist.txt"; > my $local_dir=cwd; > > open (DIR, $local_dir) or die "can nae open local directory: $!"; You cannot open a directory with open(), you need to use opendir() for that. However you are no

RE: example of placeholders

2003-06-17 Thread Johnson, Shaunn
column names) and users ... but i missed the tablenames. --that's what i have so far. --suggestions? thanks! -X -Original Message- From: K Old To: Johnson, Shaunn Sent: 6/17/03 10:56 AM Subject: RE: example of placeholders Shaunn, Can you give a description of what you are trying to do

RE: example of placeholders

2003-06-17 Thread Dan Muey
> --howdy. Howdy > > --i think i am getting closer to solving this, but > --i have ran into a problem. > > --the below program works to the point where it > --will return the data, but not ALL of the data. > > --for example, i get only about 50 or so lines when > --if i do the queries by hand

RE: example of placeholders

2003-06-17 Thread Johnson, Shaunn
--howdy. --i think i am getting closer to solving this, but --i have ran into a problem. --the below program works to the point where it --will return the data, but not ALL of the data. --for example, i get only about 50 or so lines when --if i do the queries by hand, i get over 200 with --diff