# Simple sql/variable problem

**URL:** <https://forum.kirupa.com/t/simple-sql-variable-problem/143962>\
**Category:** Uncategorized\
**Created:** [April 10, 2005, 1:22pm UTC](https://forum.kirupa.com/t/simple-sql-variable-problem/143962 "2005-04-10T13:22:40Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![imported\_FlashFish](https://avatars.discourse-cdn.com/v4/letter/i/c57346/32.png) [@imported\_FlashFish](https://forum.kirupa.com/u/imported_FlashFish)\
**Post date:** [April 10, 2005, 1:22pm UTC](https://forum.kirupa.com/t/simple-sql-variable-problem/143962/1 "2005-04-10T13:22:40Z")

</div>

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…