This is an exported version of the JIRA issue tracker. Please use the Google Code site to open new tickets or report updates to these existing tickets. Feel free to contact the mailing list with any questions.

[RRR-35] Allow multiple parameters
Created: Wed, 10 Nov 2004 15:15:27 -0800 (PST)  Updated: Wed, 12 Jan 2005 13:41:03 -0800 (PST)

Status:Closed
Project:ReportRunner
Component/s:Web Wizard
Affects Version/s:0.2
Fix Version/s:0.4

Type:ImprovementPriority: Major
Reporter:Henri YandellAssignee:Henri Yandell
Resolution:Fixed 
Environment:


 Description   
There is no input way to handle an SQL: foo IN (?,?,?,?,?)

Of course, this isn't exactly simple in the world of SQL. It might need a change to the SQL parameter system; ie: foo IN (??). Something that lets the code modify the SQL so that the setting works.

Of course, it could try to set it as an Array. Hell, maybe that actually works :)
Comment by bayard [ Wed, 29 Dec 2004 10:04:50 -0800 (PST) ]
I think this is doable nicely.

A param has a type of String[], or Date[] etc. This has to choose a particular widget, easy if there's a binding. Otherwise a textfield with comma separated perhaps.

If a param is an array, it finds the relevant ? mark in the SQL and expends it to ?,?,? etc. Then loops as usual.

A worry if ? is in the SQL and is not intended to be a parameter placeholder, but solve that later.
Comment by bayard [ Wed, 12 Jan 2005 13:41:03 -0800 (PST) ]
Done. foo IN (??) and set the type to be an array, ie) java.lang.Integer[]