Re: perl DBI does not do execute mysql statement
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 the value of $col, it works fine. The insertion was done. If I run this query with other values of $col this sql works fine if $col is not name. If $col eq "name" then the insertion does not happen and no error message is given. (Of course, if I run the same query by hand, then this works fine). I would first get some sleep, then enable DBI tracing and turn on the MySQL general query log and see what query is really getting sent to the server. Baron Hi Baron, Best advice. I forgot about this one. I fixed the bug but I don't know how. I randomly changed form feature of the connection of the DBI object. Before this I experimented the ` quote symbol it did not help. To figure out what had caused the problem I need to ask the sysadmin for this. I was working on a database that I don't have easy access of the log files. Thanks for the help. Kemin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: perl DBI does not do execute mysql statement
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 works fine. The insertion was done. If I run this query with other values of $col this sql works fine if $col is not name. If $col eq "name" then the insertion does not happen and no error message is given. (Of course, if I run the same query by hand, then this works fine). I would first get some sleep, then enable DBI tracing and turn on the MySQL general query log and see what query is really getting sent to the server. Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: perl DBI does not do execute mysql statement
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 the value of $col, it works fine. The insertion was done. If I run this query with other values of $col this sql works fine if $col is not name. If $col eq "name" then the insertion does not happen and no error message is given. (Of course, if I run the same query by hand, then this works fine). Not sure how crazy this could be. Any clue? No, because you're describing the problem in English without showing any of the code that doesn't work. How can anyone help you? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
perl DBI does not do execute mysql statement
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 insertion was done. If I run this query with other values of $col this sql works fine if $col is not name. If $col eq "name" then the insertion does not happen and no error message is given. (Of course, if I run the same query by hand, then this works fine). Not sure how crazy this could be. Any clue? Kemin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]