Geo Coder mysql Query
2 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: April 13, 2012 (RSS)
By concrete - April 12, 2012
I'm using codeigniter as my frontend application and im having trouble duplicating the query for the geo coder.
Is is possible to post the full query so that i may use it in my application.
Is is possible to post the full query so that i may use it in my application.
Re: [concrete] Geo Coder mysql Query
By Jason - April 13, 2012
Hi,
Are you referring to the code used for a search? The search query is generated dynamically using a function called geocoder_getOptions(), so you can take a look at that function to get an idea of how things work.
If you just need to see an example of what this produces, you can use the 'debugSql' option on the geocoder search example page:
Hope this helps
Are you referring to the code used for a search? The search query is generated dynamically using a function called geocoder_getOptions(), so you can take a look at that function to get an idea of how things work.
If you just need to see an example of what this produces, you can use the 'debugSql' option on the geocoder search example page:
// get records
list($addressRecords, $addressMetaData) = getRecords(array(
'tableName' => $GLOBALS['GEOCODER_SAMPLE_TABLENAME'],
'debugSql' => true,
) + $geoOptions); // geoOptions WILL NOT override the above optionsHope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/