Incorrect syntax near Waltz !

Hello to everyone,

I am developing a web site connected to an sql server 2000.I recently stepped onto this error message.I googled it but didn't find anything.

I do not have any variables,tables or fields named this way.

Have you guys met this error message before?

thanks in advance

Line 1: Incorrect syntax near 'Waltz'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'Waltz'.

Source Error:

Line 289:
Line 290: UpdateFilename.Connection.Open()
Line 291: UpdateFilename.ExecuteNonQuery()
Line 292: UpdateFilename.Connection.Close()
Line 293:

Source File:c:\inetpub\wwwroot\agrolasithiAdmin\AdvertInfo.aspx.vb Line:291

Stack Trace:

[SqlException: Line 1: Incorrect syntax near 'Waltz'.]
 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +182
 agrolasithiAdmin.AdvertInfo.SubmitBtn_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\agrolasithiAdmin\AdvertInfo.aspx.vb:291
 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
 System.Web.UI.Page.ProcessRequestMain() +1277

Are you calling a proc o executing T-SQL? Post the relevant T-SQL. Are you passing any values that contain the word "waltz".

|||

Post sql which you are using..