Onur Bolukbasi
|
| Posted: 03/09/2005, 2:09 AM |
|
Hi,
I have custom SQL and I would like to add the value of the hidden field in the where part of the SQL sentence.
like that:
select * from table where fieldname in ({Hidden1})
but when i look at the sql
select * from table where fieldname in ()
How can I assign Hidden1 value in SQL Parameter box?
What is the type of parameter source?
What is the name of the parameter, is it name part in Hidden1 Properties, Data tab?
Anybody know how I configure this?
|
|
|
 |
E43509
Posts: 283
|
| Posted: 03/10/2005, 11:12 AM |
|
Try this
select * from mytable where myname = {myctl}
Then add a parameter named myctl (set its type and format
for the parameter source change type to control and pick your hidden control.
|
 |
|
|
