How to get fetchrow result in one string

[denis60]

Hi everyone

Is it possible to get all the result of a fetchrow in one string or array like:

$result = $db->FetchRow();
or
@result = $db->FetchRow();

In VB they use getstring and getrows.

if not what is the fastest for each one.

Thanks in advence!

 

[mikevh]

Is it possible to get all the result of a fetchrow in one string or array?

You don't say what module you're using, but I think fetchrow already returns an array, no?

If it returns an array and you want to make it into a string, use join, e.g.

while (my @result = $db->FetchRow()) {
    [b]my $string = join($delim, @result);[/b]
    # do something with $string
...

perldoc -f join

 

[denis60]

Thanks MIKEVH for the info

 

[missbarbell]

I think you want something like this:

	if ( $type eq 'array' ) {
		while ( my $row = $sth->fetchrow_arrayref() ) {
			push @result, [@{$row}];
		}
	} else {
		while ( my $row = $sth->fetchrow_hashref() ) {
			push @result, $row;
		}
	}

Where $type is defined as to whether you want to return an array containing records with a list of field values, or an array containing records with a hash of field name to value.

Barbie
Leader of Birmingham Perl Mongers

http://birmingham.pm.org