ZF2-195: Zend\Db (beta3): unable not to quote a column value

Issue Type:
Bug
Created:
2012-03-06T18:00:16.000+0000
Last Updated:
2012-05-11T16:36:00.000+0000
Status:
Resolved
Fix version(s):
    Reporter:
    Fabrizio Balliano (balliano)
    Assignee:
    Ralph Schindler (ralph)
    Tags:
    • Zend\Db
    Related issues:
    Attachments:

    Description

    I'm trying to use tablegateway to insert values in a mysql' spatial column: http://pastebin.com/K6ECz0h4 but there's no way not to quote the "points" column, in ZF1 we had the Zend_Expr but I can't find anything like that in ZF2.

    Same issue applies to Zend\Db\Sql\Insert Thank you very much!

    Comments

    Posted by Roger Hunwicks (rhunwicks) on 2012-03-09T20:49:06.000+0000

    Please can someone with the correct privileges assign this to component Zend\Db

    Posted by Roger Hunwicks (rhunwicks) on 2012-03-20T06:10:18.000+0000

    This is probably fixed by https://github.com/ralphschindler/zf2/… if you "use Zend\Db\Sql\Expression" and then do

    
"point" => new Expression("GEOMFROMTEXT('POINT({$_REQUEST["lat"]} {$_REQUEST["lng"]})')"),

    I'm hoping those changes will be merged into the master branch for Beta4.

    Posted by Ralph Schindler (ralph) on 2012-05-11T14:09:20.000+0000

    I'll look into this today, I think it's a good idea.

    Posted by Ralph Schindler (ralph) on 2012-05-11T16:36:00.000+0000

    Fixed in 36e30cf (pull request #1206)