Results 1 to 2 of 2

Thread: Zend_Db_Table Query Issue

  1. #1
    Bob Luo is offline Junior Member
    Join Date
    Jun 2012
    Posts
    1

    Exclamation Zend_Db_Table Query Issue

    sql = "SELECT `professional_notes`.`Id`
    FROM `professional_notes`
    WHERE
    (NoteContent = 'drefhtpsna8ma0JC0000008WKqSMAWJ001377 [Direct HR | Dummy Job Test For Track Job Note | Ningbo, Zhejiang, China] na8salesforcecoma0KC0000004O4abMACC079175 [Bob Luo | b.luo@directhr.de | +86 000 0000 0000]'
    )
    LIMIT 1";

    When I execute it via $db->query the browser leads to some interupted connection page, not throw any error.

    I think that this issue cause by special characters in content of field 'NoteContent '. Because when I remove some characters, It execute success.

    How resolved it?

  2. #2
    Join Date
    May 2010
    Posts
    48

    Default

    Did you try escaping the special characters ?
    Learn Zend Framework Online/Offline - Visit Zend Framework Training

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •