ASP and multi value parameters

[cnice9]

I have a report that I am running from an asp page. I am using a multi select input box to get text from the user that is passed to the report like so:

<!-----Marks---------->
<cfquery name="getmarks" datasource="#session.dbname#">
select * from gradecodes
where yearid = #session.getyear# and
locationid = '#form.locationid#'
order by GradeID
</cfquery>


<tr>
<td align="right" valign="top">Grade Codes</td>
<td>
<select name="ClassGrade" size="5" multiple>
<cfloop query="getmarks">
<option value="#TRIM(GradeID)#">#TRIM(GradeID)#</option>
</cfloop>
</select>
</td>
</tr>



This works fine for single value parameters, but I need to be able to pass multiple values to a single parameter field that has been set to accept multiple values. The Crystal report works fine as a stand alone but not via asp.

Please note that I am using CR 9, and sql server 2000 and am more the happy to provide any additional information that may be needed to resolve this problem. Thanks in advance for any assistance.


C.Nice
RealTime Information Technology Inc.

http://www.realitinc.com/

 

[synapsevampire]

This looks like Cold Fusion.

Here's the ASP sample apps for CR 9:

http://support.businessobjects.com/communityCS/FilesAndUpdates/aspxmps9.exe.asp

-k