Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Run export data from links via telnet

Jul 15, 2002, 7:10 AM
dregs2
User (82 posts)
Jul 15, 2002, 7:10 AM
Post #1 of 2
Views: 1080
Shortcut
Quote Reply
Run export data from links via telnet
Hi

I want to export the data from links where it adds the category id and name.

It doesn't seem to run from the browser.

does someone know the command to do this and save to a file.

Thanks in advance

dregs2
Jul 15, 2002, 8:02 AM
Paul
Veteran (19537 posts)
Jul 15, 2002, 8:02 AM
Post #2 of 2
Views: 1039
Shortcut
Quote Reply
Re: [dregs2] Run export data from links via telnet In reply to
You just want the category id and name?

Code:
my $sth = $DB->table('Category')->select( 'ID', 'Name' );
while (my $row = $sth->fetchrow_hashref) {
$output .= "$row->{ID}|$row->{Name}\n";
}
$sth->finish();

open FH, ">cats.txt" or die $!;
print FH $output;
close FH;

Last edited by:

Paul: Jul 15, 2002, 8:03 AM