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

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

"like" query to ezpersistentobject...

Previous topic

Suggestions

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

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