[TYPO3-core] Flexform search

Bernhard Kraft kraftb at kraftb.at
Mon Jan 2 15:36:29 CET 2006


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Holzinger Franz wrote:

> Probably a library of functions for the flexforms is needed.

The search is done directly in SQL. Adding the patch will result in WHERE queries
like:

AND pi_flexform LIKE '%price%' ...

Doing the search manually in PHP would be bad in my opinion as it would take a huge amount
of time if there are many records on one page (or you are doing an infinite search from the
rootpage) because all searching would be done in PHP.

Using the posted method only uses mysql-methods for this job.

Robert noted that mySQL will support something called "xPath" sooner or later which allows
to handle XML data in database (if I understood you correctly robert)

But till this really is available will take still some time and in the meantime we could at
least offer "limited" support for search through flexforms.


greets,
Bernhard
- --
- ----------------------------------------------------------------------
"Freiheit ist immer auch die Freiheit des Andersdenkenden"
Rosa Luxemburg, 1871 - 1919
- ----------------------------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDuTptIl4dkVkDMFkRAjWpAJ9Nmq/MOh8cGL2+uJQPYpLuDUIzAQCeKDag
dzPFOfIJ3FP+2ZzQKAQyHDc=
=nRms
-----END PGP SIGNATURE-----



More information about the TYPO3-team-core mailing list