At 16:52 +0000 5/10/02, [EMAIL PROTECTED] wrote: >Well... This seems to be a typical tricky-goute-on-qoute thing... >I recommend you to test your query in mysql client directly >(if you havn't already done that).
There really are no tricky quote-on-quote things, except when people try to mess around quoting data values themselves. Follow these principles, and you'll never have a problem: - Use placeholders for data values in the query string, then pass values to be bound the placeholders when you execute the statement. or - Use $dbh->quote() to quote the values, then insert the result directly into the query string. and - Never put quotes around the placeholder characters or around a data value that has been processed by $dbh->quote(). That's it. It works for numbers, text, NULL (undef) binary stuff like images, whatever. > >And THEN take the battle with perls quoting mechanism... > >Another tip is to just print the query before executing >so You can see exactly how perl is handling with quotes. >Propably You need to espace quotes to hide them from perl. > >I think this is quote... eh.. I mean quite common way to >track down this kind of problems but I say it 'just in case' >You haven't try it yet... > >good luck :-) > >=d0Mi= --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
