[ic] Using several [data session arg] in a URL

[Ron Phipps]

> From: interchange-users-bounces at icdevgroup.org
[mailto:interchange-users-
> bounces at icdevgroup.org] On Behalf Of Lars Johansson
> Sent: Friday, June 11, 2004 11:22 PM
> 
> Hello,
> I'm trying to get my query to select data using the [data session arg]
as
> a
> filter.
> Now all works fine if I use only one argument.
> But I need two (or more) arguments..
> I'm confused on how to set this up in the query, and how to pass on
more
> then one arg in a URL (see the second code block below)
> 
> here is my code: (works)
> ------------------------
> [query sql="select distinct subcat from products where prod_group =
'[data
> session arg]'"
> type=list]
> <table width="100%" border="0" cellpadding="3" cellspacing="0"
> bgcolor="#CDD0D8">
> <tr>
> <td width="5" class="menu-bg"><img src="nav/bullet_elbow.gif"
width="12"
> height="10"></td>
> <td class="menu-bg">
> <a href="[area search=|
> 	fi=products
> 	st=db
> 	rf=*
> 	sf=prod_group
> 	se=[data session arg]
> 	op=eq
> 	sf=category
> 	se=[sql-param category]
> 	op=eq
> 	sp=category
> 	|
> 	arg="[data session arg]"]" class="txt-body">[sql-param
> subcat]</a></td>
>    </tr>
> </table>
> [/query]
> 
> --------------------
> This is what I'd like to get working (it doesn't now)
> --------------------
> [query sql="select distinct subcat from products where prod_group =
'[data
> session arg]' and category ='[data session arg2]'"
> type=list]
> <table width="100%" border="0" cellpadding="3" cellspacing="0"
> bgcolor="#CDD0D8">
> <tr>
> <td width="5" class="menu-bg"><img src="nav/bullet_elbow.gif"
width="12"
> height="10"></td>
> <td class="menu-bg">
> <a href="[area search=|
> 	fi=products
> 	st=db
> 	rf=*
> 	sf=prod_group
> 	se=[data session arg]
> 	op=eq
> 	sf=category
> 	se=[sql-param category]
> 	op=eq
> 	sp=category
> 	|
> 	arg="[data session arg]"]
> 	arg2="[sql-param category]"]
> " class="txt-body">[sql-param subcat]</a></td>
>    </tr>
> </table>
> [/query]
> ------------------
> 
> Any help this would be very welcome.
> I can't find a solution yet in the manuals..
> regards,
> Lars J.
> 

Look at the form parameter it takes the form of:

[area href='test' form='arg1=value1
				arg2=value2
				argx=valuex']

-Ron