Forums / Suggestions / "like" query to ezpersistentobject...

"like" query to ezpersistentobject...

Author Message

Jerry Jalava

Tuesday 05 August 2003 9:39:49 am

I think it would be nice if you could implement an like query possibility to ezpersistentobect also...

I had to do it like this so I could get the right kind of array sended to the template:
------
$asObject = true;
$sqlText = "SELECT * FROM test_table WHERE TestCell LIKE '%$Search%'";
$rows =& $db->arrayQuery( $sqlText,
$db_params );

return eZPersistentObject::handleRows( $rows, $class_name, $asObject );
------

Regards,
Jerry

Selmah Maxim

Sunday 10 August 2003 9:42:43 am

Hi Jerry ..

I think you can do it, else how the search goes ?

Btw .. I found how to make multi query and fetch specific rows with specific terms... I didn`t tho its can be done with this way, but its work ... Today I had finished really complex module for admin .. I hope this the last module :)

Jerry Jalava

Monday 11 August 2003 3:12:17 am

Hi Selmah,

Actually if you check the ezsearch module, it doesn't use ezpersistent object for fetcing the data. Actually it uses almoust the same way that I had to use...

Could you tell a bit more about that multiquery? Example maybe...

Thanks,
Jerry