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

Lars Johansson lars at agente.nl
Sat Jun 12 02:22:23 EDT 2004


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.



More information about the interchange-users mailing list