At 10:05 AM 12/14/2001 +0000, Simon Oliver wrote:
>This is a DBI mailing list and so you will not get much support on Win32::ODBC
>problems. If you have the time convert your code to DBI do so ASAP.
I know this is a DBI mailing list, so since Win32::DBIODBC is part of the
DBI I guess this is the appropriate place to questions about it.
>Win32::DBIODBC is an 'alpha' implementation (to be honest I can't even get it
>to connect to a data source on my machine).
>
>$sth is DBI style, not Win32::ODBC, I would use $db instead.
Ok, thanks for the tip :)
I didn't write the scripts, and I have never used Win32::ODBC myself.
Anyway it was just an example so that you would get the idea, and you did :)
> > while ($sth-FetchRow) {
>I guess you meant $sth->FetchRow, but the rest of your code looks Ok.
Typo.
>Have you tried returning the entire row as an array:
>
>while($db->FetchRow()){
> my @data = $db->Data();
> print join(', ', @data), "\n";
>}
>
>or as a hash:
>
>while($db->FetchRow()){
> my ($key, $val, %data);
> %data = $db->DataHash();
> print "$key=>$val\n" while ($key, $val) = each %data;
> print "\n";
>}
I haven't tried. I'll see what happens. Anyway that would mean to modify
all the script manually and that's what I'm trying to avoid.
>Finally, have you checked your data is what you think it is?
Yep, I'm pretty sure. I've done the same selects via psql and via pgAdmin
and I get the correct data.
>--
> Simon Oliver
Thanks, Simon, for your reply.
Javier Dussaillant G.
[EMAIL PROTECTED]
Departamento de Desarrollo VRWEB ltda.
http://www.vrweb.cl
