[ic] sql-param containing quote char in a value tag

Rich Doughty interchange-users@icdevgroup.org
Tue Feb 4 09:07:00 2003


On 04 Feb 2003, Kevin Walsh wrote:
> Rich Doughty [rich@opusvl.com] wrote:
> > 
> > i've got code similar to the following:
> > 
> > [value name="foo" set="[sql-param bar]"]
> > 
> > all is fine unless bar contains a '"' character eg
> > 
> > if [sql-param bar] is
> > 	21" widescreen
> > 
> > then
> > 	[value name="foo" set="[sql-param bar]"]
> > evaluates to
> > 	[value name="foo" set="21" widescreen"] - not good
> > 
> > i'm not sure of the internals of ic but it looks like the sql-param subtag
> > is just a straight text replacement, not like a normal tag.
> > 
> > is there any workaround for this problem?
> > 
> You could use single quotes:
> 
>     [value name="foo" set='[sql-param bar]']
> 
> or pipe characters:
> 
>     [value name="foo" set=|[sql-param bar]|]
> 
> or a temporary scratch:
> 
>     [tmpn foo][sql-param bar][/tmpn]
>     [value name="foo" set="[scratch foo]"]
> 
> or you could use [perl], [sql-calc] or even [sql-filter] etc.

obviously :-/

sorry for being such a cretin.

kind of obvious when you look at it. cheers for the help.


  - Rich Doughty