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]