SQL error - please help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

SQL error - please help

Author

Topic

jarv
Posting Yak Master

131 Posts

Posted - 2009-02-22 : 08:24:04

When i try the following SQL query, i get an error:

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

the error:

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

please help?

jarv
Posting Yak Master

131 Posts

Posted - 2009-02-22 : 11:06:59

Please someone help?!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources