MySQL Unknown Table?

[C Davis]

I am getting the following error with a simple delete statement on a MySQL database...."3687Sample"...is the filename in the record I am trying to delete.

It writes the name of the file to delete in my write statement but then generates the error.

MySQL Unknown table '3687Sample' in where clause

here is the code...any ideas

<!--#include Virtual="/shared/connection.asp" -->

<%



FileToDelete = Request("filename")


response.Write FileToDelete

sql2= "DELETE FROM videos WHERE videos.vidname=" & FileToDelete
myconn.execute(sql2)

Set upl = Server.CreateObject("SoftArtisans.FileUp")
upl.delete "D:\inetpub\bearloebe\videos\" & FileToDelete



response.redirect "VideoAdd.asp"

%>


In addition I know the fileup component works fine because the file is deleted from the directory but the error is occuring on the database.