Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my pain?

Dave, DBI User Group, Can you take a quick look at the code block below and error messages being generated when executing. Any idea why the last 2 characters of the $sql variable are getting chopped off when prepare is executed? How do I prevent the program from termininating and letting me

RE: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my pain?

-Original Message- From: BAIER, ANTHONY (TONY), ATTSI [mailto:[EMAIL PROTECTED] Sent: Thursday, November 29, 2007 11:06 AM To: STILWELL, DAVID B (DAVE), ATTLABS; dbi-users@perl.org Subject: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my

RE: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my pain?

Jonathan First off thank you for your commentary, very insightful. I am making the code changes now to add more error checking and remove the code oddity that you pointed out. The problem that I am having is that the prepare execution is truncating the last two characters of the $sql variable

Re: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my pain?

There's no solution to your problem below - there is some commentary that may, or may not, be of relevance. On Nov 29, 2007 8:06 AM, BAIER, ANTHONY (TONY), ATTSI [EMAIL PROTECTED] wrote: Can you take a quick look at the code block below and error messages being generated when executing. Any

RE: Perl DBI::prepare Question. My head is sore from banging it against the wall. Can you help ease my pain?

THANKS.IT Works!!! Using placeholders solved the problem. I will take this knowledge with me and move forward. My head feels much better thanks to all. - Tony :) -Original Message- From: Moon, John [mailto:[EMAIL PROTECTED] Sent: Thursday, November 29, 2007 11:57 AM To: