At 00:32, 19990819, sungeiway wrote:
>The below script work well when i execute it.
>But it won't work when i change the statement from
>$statement='select * from table';
>to $statement='select * from table where (id='12345') and
>Does anybody know the reason??Please give me any suggestion to overcome
You really should give us the exact error. "It won't work" could
mean a lot of things!
I think the problem is your quotes. Try this instead:
$statement = "select * from table where (id='12345') and " .
If that works, then you should study how to quote things in Perl.