Steve,
You might consider using a direct dbms action instead of a search action.
That way you have complete control over the where clause.
Or, if you have 2 price columns, say retail and wholesale, you could put
both in the criteria:
Products.retail >= <@if expr='@@user$U_Price_Display=retail' true='0'>
include empty false
and Products.wholesale >= <@if expr='@@user$U_Price_Display=wholesale'
true='0'> include empty false
That may or may not be what you want, depending on your application.
If you really want to use a search action and a custom column, this might
work:
Products.<@if expr='len(@@user$U_Price_Display)'
true='@@user$U_Price_Display' false='someNonNullableColumn'> Is Not Null
Dave Shelley
-----Original Message-----
From: Fogelson, Steve [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 12, 2003 12:17 AM
To: Witango User Group (E-mail)
Subject: Witango-Talk: Search Action
I have a search action that I want to do something special with the
"criteria". I want to add one line to the criteria as a custom column (I
think) as follows:
Products.<@var user$U_Price_Display> Is Not Null
But I only want it included if <@var user$U_Price_Display> has a value. Is
there a way to put an "if" in the search action criteria?
Thanks
Steve Fogelson
Internet Commerce Solutions
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
