Option Where with Uploads on RAND()

2 posts by 1 authors in: Forums > CMS Builder
Last Post: April 26, 2009   (RSS)

By Djulia - April 26, 2009

Hi,

I use a [font "Times New Roman"]Viewer with RAND() and that functions perfectly.

list($tableRecords, $tableMetaData) = getRecords(array(
'tableName' => 'table',
'limit' => '2',
'orderBy' => 'RAND()',

But, I would like that RAND() uses only the records which have images in the table.

I sought a solution with the option Where, but without success :
'where' => 'Uploads = true',

Does somebody have a suggestion ?

Thanks for your assistance.

Djulia