#39906 [NEW]: Unable to use place holders as part of the actual SQL query with PDO's

[iab398 at bham dot ac dot uk]

From: iab398 at bham dot ac dot uk
Operating system: Unix
PHP version: 5.2.0
PHP Bug Type: SQLite related
Bug description: Unable to use place holders as part of the actual SQL query with PDO's

Description:
------------
Example within a PHP context:

/* using sqlite 3 database SQLLDB is a define() path to the database
location elsewhere */

if (!($db = new PDO('sqlite:' . SQLLDB))) {

$error = $db->errorInfo();

die($error[2]);

}

/* the direction in which to order the query */

$direction = "ASC";

$query = $db->prepare('SELECT * FROM table_name ORDER BY value :dir');

$query->bindParam(':dir', $direction, PDO::PARAM_STR, 4);

$query->execute();

Here, a error stating that the prepare() failed occurs due to acting on a
non-object. Would it be possible to maybe allow place holders for actual
parts of the SQL query, rather than just values?

Cheers

Reproduce code:
---------------
as above.

Expected result:
----------------
for the data to be retrieved from the database and ordered either ASC or
DESC according to the value of $direction

Actual result:
--------------
PDO/SQLite error. As above.

--
Edit bug report at [url]http://bugs.php.net/?id=39906&edit=1[/url]
--
Try a CVS snapshot (PHP 4.4): [url]http://bugs.php.net/fix.php?id=39906&r=trysnapshot44[/url]
Try a CVS snapshot (PHP 5.2): [url]http://bugs.php.net/fix.php?id=39906&r=trysnapshot52[/url]
Try a CVS snapshot (PHP 6.0): [url]http://bugs.php.net/fix.php?id=39906&r=trysnapshot60[/url]
Fixed in CVS: [url]http://bugs.php.net/fix.php?id=39906&r=fixedcvs[/url]
Fixed in release: [url]http://bugs.php.net/fix.php?id=39906&r=alreadyfixed[/url]
Need backtrace: [url]http://bugs.php.net/fix.php?id=39906&r=needtrace[/url]
Need Reproduce Script: [url]http://bugs.php.net/fix.php?id=39906&r=needscript[/url]
Try newer version: [url]http://bugs.php.net/fix.php?id=39906&r=oldversion[/url]
Not developer issue: [url]http://bugs.php.net/fix.php?id=39906&r=support[/url]
Expected behavior: [url]http://bugs.php.net/fix.php?id=39906&r=notwrong[/url]
Not enough info: [url]http://bugs.php.net/fix.php?id=39906&r=notenoughinfo[/url]
Submitted twice: [url]http://bugs.php.net/fix.php?id=39906&r=submittedtwice[/url]
register_globals: [url]http://bugs.php.net/fix.php?id=39906&r=globals[/url]
PHP 3 support discontinued: [url]http://bugs.php.net/fix.php?id=39906&r=php3[/url]
Daylight Savings: [url]http://bugs.php.net/fix.php?id=39906&r=dst[/url]
IIS Stability: [url]http://bugs.php.net/fix.php?id=39906&r=isapi[/url]
Install GNU Sed: [url]http://bugs.php.net/fix.php?id=39906&r=gnused[/url]
Floating point limitations: [url]http://bugs.php.net/fix.php?id=39906&r=float[/url]
No Zend Extensions: [url]http://bugs.php.net/fix.php?id=39906&r=nozend[/url]
MySQL Configuration Error: [url]http://bugs.php.net/fix.php?id=39906&r=mysqlcfg[/url]

[tony2001@php.net]

ID: 39906
Updated by: [email]tony2001@php.net[/email]
Reported By: iab398 at bham dot ac dot uk
-Status: Open
+Status: Bogus
Bug Type: SQLite related
Operating System: Unix
PHP Version: 5.2.0
New Comment:

Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit [url]http://www.php.net/support.php[/url] as this bug system is not the
appropriate forum for asking support questions. Due to the volume
of reports we can not explain in detail here why your report is not
a bug. The support channels will be able to provide an explanation
for you.

Thank you for your interest in PHP.




Previous Comments:
------------------------------------------------------------------------

[2006-12-20 16:31:59] iab398 at bham dot ac dot uk

Description:
------------
Example within a PHP context:

/* using sqlite 3 database SQLLDB is a define() path to the database
location elsewhere */

if (!($db = new PDO('sqlite:' . SQLLDB))) {

$error = $db->errorInfo();

die($error[2]);

}

/* the direction in which to order the query */

$direction = "ASC";

$query = $db->prepare('SELECT * FROM table_name ORDER BY value :dir');

$query->bindParam(':dir', $direction, PDO::PARAM_STR, 4);

$query->execute();

Here, a error stating that the prepare() failed occurs due to acting on
a non-object. Would it be possible to maybe allow place holders for
actual parts of the SQL query, rather than just values?

Cheers

Reproduce code:
---------------
as above.

Expected result:
----------------
for the data to be retrieved from the database and ordered either ASC
or DESC according to the value of $direction

Actual result:
--------------
PDO/SQLite error. As above.


------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=39906&edit=1[/url]