OK, the re-preparing was what I didn't know about. actually, when I cut his
query, and pasted it in, I forgot to put the double quotes around the $host
to make it "$host". I do run into situations where someone has put a space
in a column name or put a or #. Usually these are in access databases
This is one of those cases where placeholders would save you a lot of grief.
The value inserted into your SQL for $host is not a valid column name. Even
if you quote it, something like "Joe's_PC" would kill it all over again.
Run 'perldoc DBI' to read the fine manual. The sections on
Michael,
I'm not sure if the reason for this is oracle specific, or something coming
from PERL, but I know I hate placeholders, and have yet to run into a
situation why they are needed (although I will acknowledge that they are
preferred by many). If I understand the cause of the error to be the
Comments below.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Steve Howard" [EMAIL PROTECTED]
To: "Michael A. Chase"