Erro de script ASP

[ZzzZ 0]

Por favor alguém me ajude a descobrir onde está o erro:

 

 

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/guestbook/guestbook_nRequest.asp, line 47

 

strSQL = "Insert into tblGuestBook (fldName, fldCity, fldCountry, fldEmail, fldURL, fldComment, fldDate, fldUID, fldContinent, fldX, fldY, fldScrollX, fldScrollY, fldCiv) values ('" & strName & "','" & strCity & "','" & strCountry & "','" & strEmail & "','" & strURL & "','" & strComment & "','" & strDate & "','" & strUID & "," & strContinent & "," & strFldX & "," & strFldY & "," strFldScrollX & "," & strFldScrollY & "," & strFldCiv & "')"

Este código está escrito em uma só linha.

Obrigado

ZzzZ

[Salgado 4]

strSQL = "Insert into tblGuestBook (fldName, fldCity, fldCountry, fldEmail, fldURL, fldComment, fldDate, fldUID, fldContinent, fldX, fldY, fldScrollX, fldScrollY, fldCiv) values ('"& strName &"','"& strCity &"','"& strCountry &"','"& strEmail &"','"& strURL &"','"& strComment &"','"& strDate &"',"& strUID &","& strContinent &","& strFldX &","& strFldY &","& strFldScrollX &","& strFldScrollY &","& strFldCiv &"')"

Estava sobrando um ' e faltando um &.

[ZzzZ 0]

strSQL = "Insert into tblGuestBook (fldName, fldCity, fldCountry, fldEmail, fldURL, fldComment, fldDate, fldUID, fldContinent, fldX, fldY, fldScrollX, fldScrollY, fldCiv) values ('"& strName &"','"& strCity &"','"& strCountry &"','"& strEmail &"','"& strURL &"','"& strComment &"','"& strDate &"',"& strUID &","& strContinent &","& strFldX &","& strFldY &","& strFldScrollX &","& strFldScrollY &","& strFldCiv &"')"

Estava sobrando um ' e faltando um &.

Obrigado Salgado valeu!!