Hi,
I have to put several scripts that were developed by someone else,
originally for win platform using Win32::ODBC and SQL server. I am using
Win32::DBIODBC, unixODBC and PostgreSQL to make this script run in my Linux
box, everything is almost working good. I say almost because when the
script selects several columns, the results come glued together!
For example if I have table doc like:
id | title
======
1 | my_fisrt_doc
2 | my_second_doc
and in the script I have:
$sth->Sql("SELECT id, title FROM doc");
while ($sth-FetchRow) {
$id = $sth->Data('id');
$title = $sth->Data('title');
print "$id - $title\n";
}
I should get:
1 - my_fisrt_doc
2 - my_second_doc
but instead I'm getting:
1my_first_doc - 1my_first_doc
2my_second_doc - 2my_second_doc
Is there a way to solve this? Is this a known bug of Win32::DBIODBC or
unixODBC PostgreSQL driver?
Thanks,
Javier Dussaillant G.
[EMAIL PROTECTED]
Departamento de Desarrollo VRWEB ltda.
http://www.vrweb.cl
