Simple sql/variable problem

What’s up with this?

authorname = Request.QueryString(“searched”)

var BookQuery = conn.execute(“Select * FROM books WHERE Author = “+authorname+””)

Apparantly, Invalid use of ‘.’, ‘!’, or ‘()’. in query expression ‘Author = J.K. Rowling’.

which means the variable works but I dont think it’s used in the sql properly.

Thanks in advance…