Bug #4713

builde sql use prepare feature

Details

Request #4713	builde sql use prepare feature
Submitted	2005-06-30 02:34 UTC
From	kenchou77 at gmail dot com
Status	Suspended
Package	DB_DataObject
PHP Version	Irrelevant
Roadmaps	(Not assigned)

Comments

[2005-06-30 02:34 UTC] kenchou77 at gmail dot com

Description:
------------
prepare & execute sql(like PEAR DB Package)

Reproduce code:
---------------
require_once 'DB/DataObject.php';

$config = parse_ini_file('../example.ini',TRUE);
foreach($config as $class=>$values) {
$options = &PEAR::getStaticProperty($class,'options');
$options = $values;
}

$sell = DB_DataObject::factory("SELL_TABLE");

$sell->whereAdd('dele = 0');
$sell->orderBy('ID DESC');
$sell->limit(0,20);

$count = $sell->find();

Expected result:
----------------
debug output:
QUERY: SELECT ... FROM (SELECT rownum as linenum, ... FROM (SELECT * FROM SELL_TABLE WHERE dele = 0 ORDER BY ID DESC ) WHERE rownum <= 20) WHERE linenum >= 1

Actual result:
--------------
for Oracle(and other db supported):
QUERY: SELECT ... FROM (SELECT rownum as linenum, ... FROM (SELECT * FROM SELL_TABLE WHERE dele = ? ORDER BY ID DESC ) WHERE rownum <= ?) WHERE linenum >= ?

[2005-06-30 04:31 UTC] kenchou77 at gmail dot com

sorry for my mistake.

Actual result:
--------------
debug output:
QUERY: SELECT *
FROM SELL_TABLE WHERE dele = 0 ORDER BY ID DESC

I hope the sql like "SELECT * FROM SELL_TABLE WHERE dele = ?"
,that can reuse by oracle.