Well, first of both shoud of failed, since you can't use ';' at the end of
you query in DBI. That simply is an end line character used by various
databaser query parsers.
Second, you should use trace() possibly at level two to trace the operation.
You can then post the output to the list.
Ilya Sterin
-----Original Message-----
From: Thomas Hillebrand
To: [EMAIL PROTECTED]
Sent: 05/02/2001 6:59 AM
Subject: Bug (?): Whitespace-Handling of DBI
Hi,
although I'm programming a lot I don't use DBI every day.
So, being more familar with perl itself, C or
SGML-Standards, I found a problem that unfortunately costed
me a whole evening to identify and I think it is some kind
of bug. I expected that both of the following expressions
should have identical results:
$myquery = "SELECT * FROM MyTable;" ;
$myquery = "SELECT * FROM MyTable; ";
But - at least on my (sorry!) Windows-PC with a
Win-32-version of Perl - they don't have! The first
expression returns the expected result table, the second one
leads to an empty table! The reason for that is the space at
the end of the string that is going to be passed to DBI! As
far as I know, according to all conventions of programming,
the space should be ignored by DBI. Like Perl itself ignores
the space at the end of the first example.
Is this a bug? Is it just a problem of the win-version? Or
is there any reason or purpose for that.
Thank you and regards
Thomas Hillebrand
