Hi again!

I have created a template column to attain variables which I want to pass over to another page. I want these variables to be placed into the WHERE clause of my sql, for example if im passing over the variables 'group' and 'qtr' the where clause will look something like:

WHERE wis_group = @group
AND wis_qtr = @qtr

I then want to place the data into another datagrid. What do I need to do for the second page to recognise the variables? Do they need to placed into a data reader? If so could someone help out with the kind of thing I need to do?

Thanks In advance, Luke

Yeeeeeha cowboy!

__________________
Yeeeeeha cowboy!

Solved this problem by using QueryString like so in the SQL Command.

WHERE SUBSTRING(wis_group,1,2) in ( '" + Request.QueryString("group") +"') and wis_quarter = '"+ Request.QueryString("qtr") +"'

Just in case someone needs this!

Yeeeeeha cowboy!