IPB

Welcome Guest ( Log In | Register )

> [Zend DB] Problem using question marks in PDO, I ran into this bug which I thought was being caused by Zend DB
admin
post Jun 19 2008, 01:10 AM
| Post #1


Administrator
**

Group: Root Admin
Posts: 10
Joined: 21-May 08
Member No.: 1



I'm getting a Zend DB Exception with a query that works in phpMyAdmin:

UPDATE creatives SET display_url = 'domain.be?Vetements-d\'enfants' WHERE display_url = 'domain.be?VĂȘtements d\'enfants'

Results in:

Zend_Db_Statement_Exception: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound in D:\Webs\Base\lib\fw\Zend\Db\Statement\Pdo.php

The exact same query works fine in phpMyadmin.

Apparently this is an issue with PDO itself: http://framework.zend.com/issues/browse/ZF-1343

It seems to be occurring when using a quote and question mark in the same string, but I cannot be sure. Has anyone else figured this out yet?
Go to the top of the page
 
+Quote Post

Posts in this topic


Fast ReplyReply to this topicStart new topic

 



RSS Lo-Fi Version Time is now: 7th September 2010 - 12:35 PM
Copyright Vitzo Limited