[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
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/