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]