80040e14 Error

[Woohoo]

Hi,

I am getting the following error when I try to delete a record. The thing is it works when I just do a straight forward delete. I am using a session variable to tell me which table they want to use. This is where I am getting the error.


conn.Execute("Delete From '" & Session("thetable") & "' Where ID ='" &currentrecord & "'")


Thanks in advance,

[NancyJ]

why do you have single quotes around your table name?

See also: http://www.aspfaq.com/show.asp?id=2400

[oracleguy]

And why do you have single quotes around your ID number? Isn't your ID column a number? If it is, then you don't/can't have single quotes there either.

[Woohoo]

why do you have single quotes around your table name?

See also: http://www.aspfaq.com/show.asp?id=2400

Lets ask the question in a different fashion. Can I use a session variable in a delete statement, and if so how?

thanks,
Bill