MultiSelect List boxes as query parameters

jdom · #1 June 29th, 2009, 02:58 PM

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 · #2 July 1st, 2009, 05:00 PM

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 · #3 July 1st, 2009, 05:07 PM

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

/bytes/development

/bytes/it

/bytes/about