How to write a delete statement?

[LovelyGirl]

Someone please help.

How can I delete from the database if the WHERE condition icludes the operator IN (variable or request.form("y&quot), y is set of numbers such as 1, 2, 3,...etc.
By the way I wrote the folloowin query but it did not work:

"Delete From x Where a IN ('" & reguest.form("y&quot & "')"

And thanks in advance.

 

[snowboardr]

<%' this may help..
dim pkey
pkey = split(request.form(&quot;pkey&quot,&quot;'&quot
for x = 0 to ubound(pkey)
sql = &quot;delete * from [my table] where primarykey=&quot; & pkey(x)
myconn.execute(sql)

Next 'moves to next in array..
%>


'pkey = id number

 

[LovelyGirl]

Thanks alot snowboardr