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

Expand|Select|Wrap|Line Numbers

 
<%

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

MultiSelect List boxes as query parameters

re: MultiSelect List boxes as query parameters

re: MultiSelect List boxes as query parameters

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/other

/bytes/about