Leser: 1
![]() |
![]() |
9 Einträge, 1 Seite |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
sub GetArray { my($this, $stmt) = @_; unless($this->{Cnn}) { Win32::MsgBox('Keine Verbindung!'); return undef; } my @retArr; my $rst = $this->{Cnn}->Execute($stmt); unless($rst->EOF and $rst->BOF) { $rst->MoveFirst; while(not $rst->EOF) { push(@retArr, [$rst->Fields(0)->{value}]); for my $_sp (0..$rst->Fields->{count}) { push(@{$retArr[$_sp]}, $rst->Fields($_sp)->{value}); } $rst->MoveNext; } } return \@retArr; }
1 2 3
my $arrRef = $adodb->GetArray('SELECT ID FROM Tabelle1'); print Dumper($arrRef); print $arrRef->[0]->[0],"\n";
push(@{$retArr[$_sp]}, $rst->Fields($_sp)->{value});
push(@{$retArr->[$_sp]}, $rst->Fields($_sp)->{value});
push($retArr[$_sp], $rst->Fields($_sp)->{value});
![]() |
![]() |
9 Einträge, 1 Seite |