Thanks, Conny! That works! But WHY does it work? There is no space in the Department field.
Dwayne From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Monday, July 13, 2009 11:53 AM To: arslist@ARSLIST.ORG Subject: AW: Allowing users to enter leading characters in search menu field ** 'Department' LIKE ($1000000000$ + "%" ) or $1000000000$ = " " don't forget the blank between the double quotes HTH Kind Regards Conny ________________________________ Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von marti...@ad.jmu.edu Gesendet: Montag, 13. Juli 2009 17:35 An: arslist@ARSLIST.ORG Betreff: Allowing users to enter leading characters in search menu field ** Dear List, I have a "Department" field (field ID 1000000000), with choices listed in a "Department Form." I want users to be able to either click on the Menu button and see all choices, or enter one or more leading characters and see the choices that begin with those letters. (Eg, type in "Eco" and then see "Ecology" and "Economics" in the menu.) If I have no qualifications in my menu it shows all choices. If my qualification says: 'Department' LIKE ($1000000000$ + "%" ) It works if the user enters a leading letter or two, but if there are no leading letters it says, "(No entries in menu)." I tried: $1000000000$ = $NULL$ OR 'Department' LIKE ($1000000000$ + "%" ) But still got "(No entries in menu)." 'Department' LIKE ( "%" + $1000000000$ + "%" ) works if there are no leading characters, but if there are leading characters, it offers choices in which the leading characters appear anywhere in the Department name. (Workable, but not ideal.) Any suggestions? (ARS 7.1 p3, RH Linux server, Oracle 10.2) Dwayne Martin James Madison University _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
