Re[2]: [INTERFACES] Perl Interface

Afternoon,

intriguing... however, how do I go to the next row? I tried a
variation earlier that looked like:

while (@row = $result->fetchrow) {
$string = join("\|",@row);
}
$result = $conn->getResult;


I've also tried :

while ($result = $conn->getResult) {
while (@row = $result->fetchrow) {
$string = join("\|",@row);
}
push(@set,$string);
}


The goal is to get multiple rows into a single array. The answer is
probally very simple.


Thx,
-Rob

______________________________ Reply Separator _________________________________
Subject: Re: [INTERFACES] Perl Interface
Author: James Olin Oden <joden(at)lee(dot)k12(dot)nc(dot)us> at INTERNET
Date: 06/22/1999 2:24 PM

Just change that $ret to @ret, and it will return the entire row.
After that your code becomes something like:

$query = "Select
username,password,knickname,emailaddy,forward,ip,date from temp";
$conn = Pg::connectdb("dbname=$dbname");
$result = $conn->exec($query);
while (@row = $result->fetchrow) {
@row = join("|", @row);
}