Hi all,
are there any best practices for generic SQL error handling like how
to test if a SELECT returned any values at all? I have noticed that
different DBD drivers seem to produce different return values on
selects - DBD-Oracle returns 0E0 if successful, DBD-CSV returns 0E0
if no row selected
I'm drawing a blank on an error I'm getting inserting a date
(2001070112:00:00) into a varchar field.
Cannot execute: You have an error in your SQL syntax near ':00:00)' at
line 1
my $sql=q{INSERT INTO some_table(the_date) values(?)};
my $sth=$dbh-prepare($sql);
$sth-execute($the_date) || die
PROTECTED]]
Sent: Tuesday, June 26, 2001 1:02 PM
To: [EMAIL PROTECTED]
Subject: sql error
I'm drawing a blank on an error I'm getting inserting a date
(2001070112:00:00) into a varchar field.
Cannot execute: You have an error in your SQL syntax near ':00:00)' at
line 1
my $sql=q{INSERT
]
Subject: sql error
I'm drawing a blank on an error I'm getting inserting a date
(2001070112:00:00) into a varchar field.
Cannot execute: You have an error in your SQL syntax near ':00:00)' at
line 1
my $sql=q{INSERT INTO some_table(the_date) values(?)};
my $sth=$dbh-prepare($sql);
$sth-execute
PROTECTED]
Subject: sql error
I'm drawing a blank on an error I'm getting inserting a date
(2001070112:00:00) into a varchar field.
Cannot execute: You have an error in your SQL syntax near ':00:00)' at
line 1
my $sql=q{INSERT INTO some_table(the_date) values(?)};
my $sth=$dbh-prepare($sql);
$sth
Jeff Thies wrote:
This is an update to a previous SQL error post. The problem is in the
placeholders.
This fails:
my $sql=q{INSERT INTO some_table(some_field) values(?)};
my $sth=$dbh-prepare($sql);
$sth-execute('some variable with a colon: in it');
This is OK:
my $sql=q{INSERT
Hi there ..
trying to install DBD::Informix on a solaris machine. I've done it on the
test server which (at least from my point if view) have an indentical
environment and that worked ok. And the perl scripts run fine.
Output from perl Makefile.PL on test server:
---OUTPUT START---
perl
::Informix with SQL error -369 (HELP!)
: Hi there ..
: trying to install DBD::Informix on a solaris machine. I've done it on the
: test server which (at least from my point if view) have an indentical
: environment and that worked ok. And the perl scripts run fine.
:
: Output from perl