Welcome, Guest. Please login or register.
Did you miss your activation email?
Oct. 06, 2008, 05:39:04 PM
47570 Posts in 10432 Topics by 5322 Members
Latest Member: euofulano
News: New to PRADO? The PRADO blog tutorial is a good start point.
 
The PRADO Community » Prado v3.x » General Discussion » Order by RAND() error on PRADO update « previous next »
Pages: [1] Print
Author Topic: Order by RAND() error on PRADO update  (Read 473 times)
Dynata
Senior Member
***

Karma: 0
Offline Offline

Posts: 100



View Profile
« on: Apr. 10, 2008, 11:46:42 AM »

Hello

I have this statement  on a query

Code:
$sql = "select * from mod_images_item where images_status = 2 [b]order by rand()[/b] limit 0,20";
$this->data=images::finder()->withspace()->findbysql($sql);
$this->repeater->DataSource=$this->data;
$this->repeater->dataBind();

But since I updated my PRADO 3.1 version in order to fix the ControlCssClass bug I get this error message on the sql query

Code:
Invalid column name 'rand()' for database table '`mod_images_item`'.

My whole application is failing. Any ideas about why is this order by rand() feature not working anymore?

thanks
Logged
Thor
Senior Member
***

Karma: 2
Offline Offline

Posts: 74



View Profile WWW
« Reply #1 on: Apr. 22, 2008, 09:46:44 AM »

This is a duplicate of http://www.pradosoft.com/forum/index.php/topic,9797.new.html . Please follow that topic for progress. Thanks! (and please lock this one down)
Logged

Pages: [1] Print 
« previous next »
Jump to: