关于sql语句的问题，急！！！！！！！！！！！！！

[darkdragon1981]

sql语句如下：
select * from shopmsg where shopname='kk'
上句中的kk可不可以是一个变量名，我是用request.querystring来获取的变量，
kk=request.querystring
这句sql语句总是出错，是不是kk不可以是一个变量？？
请指教！！

[maxid]

kk = request.querystring("test")
SQL = "select * from shopmsg where shopname='<%=kk%>'"
conn.execute(SQL)

[maxid]

kk = request.querystring("test")
SQL = "select * from shopmsg where shopname='&kk&'"
conn.execute(SQL)

[maxid]

<%
kk = request.querystring("test")
SQL = "select * from shopmsg where shopname='"&kk&"'"
conn.execute(SQL)
%>

[0225107]

或许不是那个错呢?是不是该在from后的词用上一个中括号呢

[0225107]

<%
kk=request(response("test"))
sql="select*from [shopmsg] where shopname='"kk"'"
conn.execute(SQL)
%>

[ttt2]

select * from shopmsg where shopname='"&kk&"'"

[dicklee1214]

<%
kk = request.querystring("test")
SQL = "select * from shopmsg where shopname='"&kk&"'"
conn.execute(SQL)
%>