Welcome to the Monastery | |
PerlMonks |
Re: Mysql error near values(by GhodMode (Pilgrim) |
on Feb 05, 2006 at 11:36 UTC ( [id://528057]=note: print w/replies, xml ) | Need Help?? |
It's hard to find the error because your code is all on one line, but it looks like the problem is that your URL isn't quoted. That must be the problem. Using placeholders might make it easier for you to code if you are using a loop to execute the statements, but it might not give you a performance benefit in MySQL. MySQL doesn't support server-side prepared statements by default and I think that's where the performance benefit comes in with placeholders and bind values. I've had some problems with turning on this setting on, but try it if you want to experiment with it. ref: DBD::mysql (search for "prepared"). Columns with character data types will need quotes. You can quote everything, though because it won't break anything with the other data types. MySQL will tell you what's wrong if you set up your queries properly. Break it back out to more lines during troubleshooting, then condense it again when everything works. Here's my suggested method:
-- -- GhodMode
In Section
Seekers of Perl Wisdom
|
|