MultiSelect List boxes as query parameters

[jdom]

i am trying to pass the value "comapre" of 2,3, or 4 checkbox to next page
but i am getting errors.
Application uses a value of the wrong type for the current operation. LINE
rsSearch_cmd.Parameters.Append rsSearch_cmd.CreateParameter("param1", 5, 1, -1, rsSearch__MMColParam) ' adDouble

Query string is like this

compare.asp?compare=466&compare=4600

<%
Dim rsSearch__MMColParam
rsSearch__MMColParam = "%"
If (Request.QueryString("compare") <> "") Then 
  rsSearch__MMColParam = Request.QueryString("compare")
End If
%>
<%
Dim rsSearch
Dim rsSearch_cmd
Dim rsSearch_numRows
 
Set rsSearch_cmd = Server.CreateObject ("ADODB.Command")
rsSearch_cmd.ActiveConnection = MM_classifieds_STRING
rsSearch_cmd.CommandText = "SELECT * FROM dbo.NEWS WHERE NEWS_ID IN (?)" 
rsSearch_cmd.Prepared = true
rsSearch_cmd.Parameters.Append rsSearch_cmd.CreateParameter("param1", 5, 1, -1, rsSearch__MMColParam) ' adDouble
 
Set rsSearch = rsSearch_cmd.Execute
rsSearch_numRows = 0
 
 
%>  
 

Is there another way to do this.

Thank you

[jhardman]

every point of data that goes through querystring is interpreted as a string. You will have to convert it to a number with cint() or some such. does this make sense?

Jared

[jdom]

can you guide to some kind of tutorial how to this

Thank you