[ic] Interpolating sql results

[Sam Phillips]

graham hadgraft wrote:
> I have a sql-field which along with text contains interchange tags. e.g.
> 
> this text is [filter keyword]filtered[/filter]
> 
> Where the keyword filter creates a link using the contained word.
> 
> The filter works outside of the sql-param tag and creates a link
> however this filter exists in the text of an sql field and when i
> print the sql-results like the following.
> 
> [query type=list sql=|SOME QUERY|]
>     [sql-param fieldname]
> [/query]
> 
> it prints the text [filter keyword] and [/filter] rather than running
> the filter.
> 
> I have tried placing interpolate=1 in both the query tag and the
> sql-param tag neither would run the filter.
> 
> The query and the filter work just not together.  How can i get it to
> run the filter before returning the contents of the field
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
> 

Check out the safe_data Pragma setting, either in page or per catalog.

http://www.icdevgroup.org/docs/pragmas.html#safe_data

Sam.

--
Sam Phillips
Interchange Developer, Webmaint
t| +44/0 870 745 0770	f| +44/0 870 745 0771	e| samp at webmaint.com

Webmaint.com - Building Clever Websites
--