Take the 2-minute tour ×

I am trying to let go of quotes in the query for inserting a value for Geometry field. This required because I need to pass a text string to the database function. If these quotes are escaped, there is no way the function POINT is going to be treated as function in the query.


GeomFromText( 'POINT(18.22 33.21)' )

So the Database is supposed to execute the function with the text parameter. But when we send this through the Joomla database object active record(Pear DB), it escapes the quotes and hence the function is not being called.

I know I can get through with it by using plain SQL instead of the PearDB. But I want to know if there is anyway we can make the quotes to be NOT escaped in the query when sent to PearDB (like for insertObject function).


share|improve this question
Please tell me that you're not intending to use unescaped user input directly in a database query... –  DaveRandom Jan 20 '12 at 11:00
Dave, I am well aware of that and make sure I do not let go unescaped user-input into db query. I just want the quotes to go through for this instance. –  John Kentucky Jan 20 '12 at 11:53
add comment


Your Answer



Browse other questions tagged or ask your own question.