Re: explain table within perl DBI

2002-02-14 Thread Paul DuBois
At 15:51 -0800 2/14/02, Brian Warn wrote: >When I run the code below, information about the first column in each >table in my list is excluded. Any ideas why? Why are you reading a row into @row_ary? I bet you're thinking that row will correspond to the row of column headers that you'd see wer

Re: explain table within perl DBI

2002-02-14 Thread Keith C. Ivey
On 14 Feb 2002, at 15:51, Brian Warn wrote: > When I run the code below, information about the first column in each > table in my list is excluded. Any ideas why? [snip] > @row_ary = $sth->fetchrow_array; You've read that information into @row_ary, but then you never do anything with it

explain table within perl DBI

2002-02-14 Thread Brian Warn
When I run the code below, information about the first column in each table in my list is excluded. Any ideas why? @table_listing=`cat /usr/local/file.txt`; # contains table list used below $dbh = DBI->connect("dbi:mysql:database=dbname;host=hostIP;port=port_number", "user", "password") or di