RE: [PEAR] Re: [PEAR-DEV] RE: [PEAR] DB insufficient data error

Ok...it all makes more sense to me now, thanks to all of you who have contributed! What I will end up doing is a prepare and then execute with the values of the fields included as bind parameters. I wasn't thinking about how the parser needed to parse the query string to decide where to fill placeholders with the bind parameters. So, with that in mind I should be good to go. Thanks again for the help! Matt -----Original Message----- From: Daniel Convissor [mailto:danielc@analysisandsolutions.com] Sent: Wednesday, March 03, 2004 10:20 AM To: Firman Wandayandi Cc: matt@wiredata.com; PEAR-DEV; PEAR-GEN Subject: [PEAR] Re: [PEAR-DEV] RE: [PEAR] DB insufficient data error Hi: As someone else mentioned, ?, & and ! are placeholder characters. I just realized I forgot to document the following new functionality: Use backslashes to escape placeholder characters if you don't want them to be interpreted as placeholders: UPDATE foo SET col=? WHERE col='over \& under' Enjoy, --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming http://www.AnalysisAndSolutions.com/ 4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409 -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php