Let This Serve As A Lesson…
I’ve just spent the past two hours today, and two hours on Wednesday, hunting down a bug that popped up when we migrated PEAR database objects from DB to MDB2. Turns out, two single quote marks: ’ ’ in a select clause is completely fine with DB, but MDB2 won’t even parse an SQL statement with those in them for prepared statement placeholders.
Good god. That was painful.