The query will be
'Title' LIKE ("%" + ($Title$ + "%"))
But this may return multiple records. Thus to have a title is difficult.
To have one record to be set, use the If Multiple request set to Use the
first matching request or have the title specific.
Regards,
Sonal
Kaiser Norm E CIV USAF 96 CS/SCCE wrote:
**
Turn it around. Like this:
‘Title’ LIKE “%” + $Title$ + “%”
------------------------------------------------------------------------
*From:* Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] *On Behalf Of *Sokol, Brian
*Sent:* Wednesday, April 18, 2007 2:03 PM
*To:* [email protected]
*Subject:* Query Question
Hi I must be doing something wrong but can not see what it is. I have
an Active Link that opens a Display Only dialog with a character
field. I am trying to search the value in that character field against
a field in another table. Here is the qualification of the AL that is
running the query:
$Title$ LIKE "%" + 'Title' + "%"
I have done this plenty of times but can not see what is wrong for the
life of me.
Brian Sokol
Manager, Desktop Services
Scholastic Inc.
557 Broadway
NY, NY 10012
(212) 343-6494
http://www.Scholastic.com
__20060125_______________________This posting was submitted with HTML
in it___ __20060125_______________________This posting was submitted
with HTML in it___
--
[EMAIL PROTECTED]
www.vyomlabs.com
Consulting | Oursourcing | Training || BMC Remedy BSM | ITIL | IT Governance
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
