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, right truncation (SQL-01004) a
. 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 access by using $temp[0] for the firs
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
Simple,
After you prepare the sql statement you must execute the statement. See the
non indented line of code below.
my $dbh=DBI->connect($db, ,$username,$password)
or die "Couldn't connect".DBI->errstr;
my $sth=$dbh->prepare('SELECT * FROM tbl_clients')
