Skip to main content

Doctrine 1.2 / Zend



Im having trouble with doctrine generating the code for a query that has a umlaut in.







$q = Doctrine_Query::create()

->select('DISTINCT p.project_name, fqha.form_question_has_answer_request, fqha.form_question_has_answer_form_id, fqha.form_question_has_answer_user_id,

u.user_username, c.company_hall_no, c.company_type, c.company_company_name, c.company_country, c.company_stand_number,

c.company_image_file_1, pchu.project_company_has_user_project_id, pchu.project_company_has_user_user_id')

->from('Klarents_Model_ProjectCompanyHasUser pchu')

->innerJoin('pchu.Klarents_Model_Company c')

->innerJoin('pchu.Klarents_Model_Project p')

->innerJoin('pchu.Klarents_Model_User u')

->innerJoin('pchu.Klarents_Model_Form f')

->leftJoin('pchu.Klarents_Model_FormQuestionHasAnswer fqha ON fqha.form_question_has_answer_form_id = ' . $this->zone_form_id . ' AND fqha.form_question_has_answer_user_id = pchu.project_company_has_user_user_id');

$sql = '(f.form_template_name = "custom" AND pchu.project_company_has_user_garbage_collection = 0 AND pchu.project_company_has_user_project_id = ' .$input->projectid .')';

if ($input->keyword !== 'Search...') {

$sql .= 'AND (c.company_company_name LIKE "%' . 'Süddeutsche'/* (html_entity_decode($input->keyword)) */ . '%" OR

c.company_stand_number LIKE "%' . 'Süddeutsche'/* mysql_escape_string(html_entity_decode($input->keyword)) */ . '%" OR

c.company_town_city LIKE "%' . 'Süddeutsche'/* mysql_escape_string(html_entity_decode($input->keyword)) */ . '%" OR

c.company_county LIKE "%' . 'Süddeutsche'/* mysql_escape_string(html_entity_decode($input->keyword)) */ . '%" OR

c.company_website LIKE "%' . 'Süddeutsche'/* mysql_escape_string(html_entity_decode($input->keyword)) */ . '%" OR

c.company_address_1 LIKE "%' . 'Süddeutsche'/* mysql_escape_string(html_entity_decode($input->keyword)) */ . '%" OR

c.company_address_2 LIKE "%' . 'Süddeutsche'/* mysql_escape_string(html_entity_decode($input->keyword)) */ . '%" OR

c.company_address_3 LIKE "%' . 'Süddeutsche'/* mysql_escape_string(html_entity_decode($input->keyword)) */ . '%" OR

c.company_hall_no LIKE "%' . 'Süddeutsche'/* mysql_escape_string(html_entity_decode($input->keyword)) */ . '%" OR

c.company_postcode LIKE "%' . 'Süddeutsche'/* mysql_escape_string(html_entity_decode($input->keyword)) */ . '%" OR

(fqha.form_question_has_answer_request REGEXP "' . 'Süddeutsche'/* mysql_escape_string(html_entity_decode($input->keyword)) */ . '"))';

}//var_dump($sql);die();

$q->Where($sql);

$file_uri = APPLICATION_PATH . '/../languages/29/messages.de.php';

if (file_exists($file_uri)) {

$countri = include($file_uri);

}

$this->view->countryTranslate = $countri;

if (strtolower($input->country) !== 'please select') {

$q->andWhere('LCASE(c.company_country) LIKE "%' . strtolower($input->country) . '%" '

. 'OR LCASE(c.company_country) LIKE "%' . ((strlen($input->country) <= 3) ? strtolower($countri[strtoupper($input->country)]) : strtolower($countri[ucwords($input->country)])) . '%"');

}

$q->orderBy(sprintf('%s %s',

(($input->sort == "") ? 'c.company_company_name' : str_replace('-', '_', $input->sort)),

(($input->dir == "") ? 'asc' : $input->dir))

);

$row_result = $q->fetchArray();







If the word 'Süddeutsche' is anyword containing an umlaut the query will show as null using Imind profiler in firefox (outputs the query string).





If its anything without an umlaut then theres no problem.





Any clue whats casuing this? I have been assuming its the characterset used with doctrine, but not sure to be honest..





Regards


Comments

Popular posts from this blog

Slow Android emulator

I have a 2.67 GHz Celeron processor, 1.21 GB of RAM on a x86 Windows XP Professional machine. My understanding is that the Android emulator should start fairly quickly on such a machine, but for me it does not. I have followed all instructions in setting up the IDE, SDKs, JDKs and such and have had some success in staring the emulator quickly but is very particulary. How can I, if possible, fix this problem?

CCNA 3 Final Exam => latest version

1 . Which security protocol or measure would provide the greatest protection for a wireless LAN? WPA2 cloaking SSIDs shared WEP key MAC address filtering   2 . Refer to the exhibit. All trunk links are operational and all VLANs are allowed on all trunk links. An ARP request is sent by computer 5. Which device or devices will receive this message? only computer 4 computer 3 and RTR-A computer 4 and RTR-A computer 1, computer 2, computer 4, and RTR-A computer 1, computer 2, computer 3, computer 4, and RTR-A all of the computers and the router   3 . Refer to the exhibit. Hosts A and B, connected to hub HB1, attempt to transmit a frame at the same time but a collision occurs. Which hosts will receive the collision jamming signal? only hosts A and B only hosts A, B, and C only hosts A, B, C, and D only hosts A, B, C, and E   4 . Refer to the exhibit. Router RA receives a packet with a source address of 192.168.1.65 and a destination address of 192.168.1.161...