Menu

#22 Parameter entry flexibility

open
nobody
None
5
2006-07-31
2003-09-02
No

Hello,

I would like to have the ability to enter parameters for
the SQL 'in' clause. AFAICS The current parameter types do
not allow this. If I set the where clause to:

in ({?myid})

I should be able to type in:

10

to see item 10, or:

10,12,16,17,31

To get a report on those items. Currently if I set the
parameter type to number I get an exception when
I enter comma separated values. Setting the type of
string returns no rows (probably because it quotes
it for me).

Discussion

  • Jim Menard

    Jim Menard - 2003-11-08
    • assigned_to: nobody --> jmenard
     
  • Jim Menard

    Jim Menard - 2006-07-31
    • assigned_to: jmenard --> nobody
     

Log in to post a comment.