[ic] abit of help on an [if] tag please

Dennis Chen interchange-users@icdevgroup.org
Fri Jul 19 17:30:01 2002


I'm trying to do an [if] comparision inside a query but I guess my [if] tags
are wrong.
There's not much docs about [if-sql] tags and the ones that I found on the
interchange lists didn't work either.  Here's my code below.

<select name="issue_agency" >
[query sql="SELECT * FROM agency" type=list]
    <option value="[sql-param code]" 	
	[if term="sql-param code" op="eq" compare="/[value issue_agency]/"
] selected [/if]>
	[sql-param issue_agency]
    </option>
[/query]
</select>


also found a snippit of code which I changed and didn't work either...
[set agency_code][value issue_agency][/set] 
[if type=explicit compare="($Scratch->{agency_code} =~ "/[value
issue_agency/"] selected 
[else] problems! [value issue_agency]  [/else]
[/if]

I just wanted to print SELECTED on the drop down list.  
Thanks for the help.
Dennis