[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