Re: perl DBI does not do execute mysql statement

2007-06-11 Thread Kemin Zhou
Baron Schwartz wrote: Kemin Zhou wrote: Hi All, I have one of the toughest problem to solve now. I have not been able to sleep well in the last three days. There is a simple query insert into table foo (column1, column2, column5) select $col from bar If I run this query by hand whatever th

Re: perl DBI does not do execute mysql statement

2007-06-09 Thread Baron Schwartz
Kemin Zhou wrote: Hi All, I have one of the toughest problem to solve now. I have not been able to sleep well in the last three days. There is a simple query insert into table foo (column1, column2, column5) select $col from bar If I run this query by hand whatever the value of $col, it wor

Re: perl DBI does not do execute mysql statement

2007-06-09 Thread Paul DuBois
At 6:54 PM -0700 6/9/07, Kemin Zhou wrote: Hi All, I have one of the toughest problem to solve now. I have not been able to sleep well in the last three days. There is a simple query insert into table foo (column1, column2, column5) select $col from bar If I run this query by hand whatever

perl DBI does not do execute mysql statement

2007-06-09 Thread Kemin Zhou
Hi All, I have one of the toughest problem to solve now. I have not been able to sleep well in the last three days. There is a simple query insert into table foo (column1, column2, column5) select $col from bar If I run this query by hand whatever the value of $col, it works fine. The ins