...

View Full Version : SQL statement error - pls help



jarv
02-22-2009, 01:21 PM
When i try the following SQL query, i get an error:

Expr1: "<Placemark><name>" & [rsPubname] & "</name><description><!
[CDATA[" & [rsAddress] & "<br>" & [rsTown] & "<br>" & [rsCounty] &
"<br><br>mypubspace.com - More info, click the
link:<br><href><Link>http://www.mypubspace.com/viewpub1.asp?PubID=" &
[PubID] & "</Link></href><br>]]></description><Point><coordinates>" &
[rsLong] & "," & [rsLat] & "</coordinates></Point></Placemark>"

the error:

invalid SQL statement expected 'INSERT', 'DELETE, 'SELECT' etc;;

please help?

CyberPirate
02-22-2009, 04:52 PM
If you give us your SQL query it will be easier for us to solve your problem :)

jarv
02-22-2009, 08:29 PM
If you give us your SQL query it will be easier for us to solve your problem :)

see my SQL above, it's suppose to output a list form my database in KML (google earth) format

djm0219
02-22-2009, 08:31 PM
There's no query in what you posted which is why CyberPirate asked for it.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum