"like" query to ezpersistentobject...

Next topic

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

Author

Message

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