Interchange Developer Resource
[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date ][Interchange by thread ]

[ic] IF comparison question



> > Someone can correct me if I am wrong, but I don't think you are comparing
> > anything.
> >
> > [if eq [sql-param foo]]
> >
> > maybe something more like
> >
> > [if foo eq [sql-param foo]]
> >
> I'm trying to check if a value that a sql-query returns is empty or not...
> Unfortunately I don't always know what I'm doing ;-)
> 
Try something like this:

    [if term="[sql-param foo]" op="ne" compare=""]

Or this (true or false):

    [if type="explicit" compare="[sql-param foo]"]

When using "explicit", remember that zero is false even though
it is not an "empty" value.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/



Search for: Sort by: