Zum Inhalt springen

Kickstarter Search [sword] case-sensitive?

Erstellt am 14. Dezember 2009 · Noch keine Antworten

Tags: Datenbank, Frage

Geddo ·

Moin 🙂

ich hab ein Problem mit einer Extension Suche die ich mir mit dem Kickstarter zusammengeschustert habe:

function main($content, $conf)	{
		switch((string)$conf['CMD'])	{
			case 'singleView':
				list($t) = explode(':',$this->cObj->currentRecord);
				$this->internal['currentTable']=$t;
				$this->internal['currentRow']=$this->cObj->data;
				return $this->pi_wrapInBaseClass($this->singleView($content, $conf));
			break;
			default:
				if (strstr($this->cObj->currentRecord,'tt_content'))	{
					$conf['pidList'] = $this->cObj->data['pages'];
					$conf['recursive'] = $this->cObj->data['recursive'];
				}
				return $this->pi_wrapInBaseClass($this->listView($content, $conf));
			break;
		}
	}
// Initializing the query parameters:
$this->piVars['sort'] = 'name:0';      // 1== Descending, 0 == ascending
list($this->internal['orderBy'],$this->internal['descFlag']) = explode(':',$this->piVars['sort']);
$this->internal['results_at_a_time']=t3lib_div::intInRange($lConf['results_at_a_time'],0,1000,999);		// Number of results to show in a listing.
$this->internal['maxPages']=t3lib_div::intInRange($lConf['maxPages'],0,1000,2); // The maximum number of "pages" in the browse-box: "Page 1", "Page 2", etc.
$this->internal['searchFieldList']='name,strasse,plz,ort,telefon,telefax,email,web';
$this->internal['orderByList']='name,strasse,plz,ort,telefon,telefax,email,web';

// Get number of records:
$res = $this->pi_exec_query('tx_meinedb',1);
list($this->internal['res_count']) = $GLOBALS['TYPO3_DB']->sql_fetch_row($res); // Make listing query, pass query to SQL database:
$res = $this->pi_exec_query('tx_meinedb');
$this->internal['currentTable'] = 'tx_meinedb';

Jede Eingabe ist dabei Case-Sensitive 🙁 Wie kann ich das umgehen?
Vielen Dank!