The following SQL statement casts the *page *column (type = string) as a
number and sorts it as such. It runs fine against a mysql database console.
select title, *page* from articles where issue_id = '18641' order by (page
*1);
I can not get the *Order by (page *1) *to function in a Zend_Db_Select. Is
there way to do this? The documentation does not indicate that Order by
can take an expression.
$sql = new Sql($adapter);
$select = $sql->select();
$select->from(array('a'=>'articles'),
array('title', 'page'));
$select->where(array('issue_id'=>$value));
* $select->order(array('(page*1)'));*
$statement = $sql->prepareStatementForSqlObject($select);
$results = $statement->execute();
--
------------------------------------------------
John Wynstra
Library Information Systems Specialist
Rod Library
University of Northern Iowa
Cedar Falls, IA 50613
[email protected]
(319)273-6399
------------------------------------------------
