How do I reset dataset (statement handle) pointer?

rupert <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase.devel
Organization http://groups.google.com
Message-ID <[email protected]>
I need to find a function or method that will reset or seek the
dataset handle back to the beginning so I can fetchrow all over again
without doing execute() functions all the time...

[code]
$dbConnection->{FetchHashKeyName} = "NAME_lc";
$dataGrid = $dbConnection->prepare("SELECT field, type FROM list");
$dataGrid->execute();

for($i=0; $i<3; $i++){

	while ($fieldRow = $dataGrid->fetchrow_hashref()) {
		print $fieldRow->{'field'};
	}

	#Nee to seek back to first row in $dataGrid here;
	$dataGrid->seekBackToFirstRow(); #I need a function to do it here...
	#fails because no such method exists to do above
}
$dataGrid->finish();
[/code]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.