SQL statement error - pls help

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?

If you give us your SQL query it will be easier for us to solve your problem :)

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

There's no query in what you posted which is why CyberPirate asked for it.