[ic] what is wrong with my query?

Dennis Chen interchange-users@icdevgroup.org
Mon Jul 22 17:07:04 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 issue_agency" 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 when the 
[value issue_agency] == [sql-param issue_agency].  

Thanks for the help.
Dennis