[TYPO3-english] Is this a fullQuoteStr mistake?

Luming Xing xingluming at googlemail.com
Mon Apr 6 00:22:14 CEST 2009


Hello Everyone,
I'm working on a search function.  user can just use a part of a book name
to search fully book name.

I have some troube in following code, No result is returned.  how sould i
do, Is there any mistake in SQL LIKE field? or a fullQuoteStr mistake?

Thank you for all help!

        $res=$GLOBALS['TYPO3_DB']->exec_SELECTquery(
          '*',   #select
          'tx_romoduxing_module', #from

'modul_name='.$GLOBALS['TYPO3_DB']->escapeStrForLike($this->piVars['modul_name'],
'tx_romoduxing_module'),
          #'modul_name like
\'%'.$GLOBALS['TYPO3_DB']->fullQuoteStr($this->piVars['modul_name'],
'tx_romoduxing_module').'%\'',
          '',
          '',
          '');

Luming xing


More information about the TYPO3-english mailing list