Tony Esposito wrote:
> ERROR:
> sth->fetchrow_array fails with ODBC (DBD::ODBC) connection to SQL Server but
> works fine with ORACLE using DBDOracle. See error below ...
>
> DBD::ODBC::st fetchrow_array failed: [Microsoft][ODBC SQL Server
> Driver]String d
> ata, rig
ERROR:
sth->fetchrow_array fails with ODBC (DBD::ODBC) connection to SQL Server but
works fine with ORACLE using DBDOracle. See error below ...
DBD::ODBC::st fetchrow_array failed: [Microsoft][ODBC SQL Server Driver]String d
ata, right truncation (SQL-01004) at create_data_dump.pl line
. If you need a copy, just
let me know and I'll send it to you. Also, there is another group out there
([EMAIL PROTECTED]) that may also be able to offer help.
Hope this helps,
Chris
-Original Message-
From: Dan Muey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 9:32 AM
T
> Hi All
Howdy
>
> I my query a MySQL database and have the following code
>
> while (@temp = $table->fetchrow_array ()) {
> some code
> {
I think you mean } not { :)
>
> my problem is that I want the results from the database query
> to be
Hi All
I my query a MySQL database and have the following code
while (@temp = $table->fetchrow_array ()) {
some code
{
my problem is that I want the results from the database query to be access by
using $temp[0] for the first row then $temp[1] for the second row and so on.
Wow, that was really simple. I guess that's what happens when you stare
at something way too long. I was going off in all kinds of wrong
directions. Thanks!
On Wed, 25 Jul 2001 11:30:26 -0700, Venkat Mohan wrote:
> RE: fetchrow_array problem with DBI
>
>Simple,
>After yo
x27;SELECT * FROM tbl_clients')
or die "Couldn't prepare statement: " . $dbh;
$sth->execute() or die "Execute Failed";
my @data;
while(@data=$sth->fetchrow_array()) { ## The offending line
my $clientid=$data[1];
parse the data in different ways. I
wanted to start off by simply printing some data (as I did not create the
tables and want to see what the data actually looks like). Below is the
code I am using to do that. The error message I am getting is
"DBD::Pg::st fetchrow_array failed: no state at q