[postgis-users] Quote problem in query
kobben at itc.nl
Mon Apr 24 05:47:35 PDT 2006
I am not sure about PhP (never use it myself), but in most script and programming langauges I do know, you can 'escape' the quote , usually by putting a \ in front, so your string could be
" WHERE table.id = other_table.id AND table.name = \"Algeria\") AS foo USING UNIQUE uid USING srid=-1"
If this does not work, check a PhP tutorial/book on how to escape characters in strings...
International Institute for Geo-information
Sciences and Earth Observation (ITC)
PO Box 6, 7500AA Enschede (The Netherlands)
ph: +31 (0)53 4874253; fax: +31 (0)53 4874335
More information about the postgis-users