I did see that in the documentation and tried it -- to no avail. I've concluded that the LIKE operator may not work in conjunction with the OOTB file adapter provided by BMC with the AIE engine. JT's method was useful, with the > and < but doesn't allow for a multi search function so you can't have ((this>'a' and this <'b') or (this >y and this<z)). At any rate, I had the people who supplied the file indicate in the file what type of system it was so the query could do an = search instead of using the like qualifier. Thanks for the input. Janie
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Zainub Gaffoor - BCX Sent: Wednesday, September 10, 2008 1:40 AM To: [email protected] Subject: Re: AIE Flatfile External Vendor Query ** Seems like wildcards are not needed when using the LIKE statement. In reference to the AIE administrators guide (page 56) - see excerpt below: LIKE Performs a pattern search. For example, 'Submitter' LIKE "Bob" finds all requests with a submitter name that begins with the letters "Bob" (such as Bobby Compton). So in effect you should try - Computername like "ES" From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: 09 September 2008 06:13 PM To: [email protected] Subject: Re: AIE Flatfile External Vendor Query ** Wildcards seem to not work. However, > and < do. Would something like this satisfy your requirements? Computername > "ES" AND Computername < "ET" --- J.T. Shyman _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Tuesday, September 09, 2008 10:58 AM To: [email protected] Subject: Re: AIE Flatfile External Vendor Query LIKE is a database operator and may not work with an external data source that is a flat file. Wonder if this would work: Computername = "ES*" .just a shot in the dark --- J.T. Shyman _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Janie Sent: Tuesday, September 09, 2008 10:36 AM To: [email protected] Subject: Re: AIE Flatfile External Vendor Query I did try that as well. It doesn't pick anything up. If I do Computername = "ESxxx" that works. It just seems that the LIKE qualifier will not find any rows. Any more ideas? Thanks, Janie _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Zainub Gaffoor - BCX Sent: Tuesday, September 09, 2008 12:43 AM To: [email protected] Subject: Re: AIE Flatfile External Vendor Query ** Hi Janie, Try using double quotes. i.e. Computername like "ES%" Hope that helps J From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Janie Sent: 09 September 2008 06:12 AM To: [email protected] Subject: AIE Flatfile External Vendor Query ** Hi, Does anyone have a sample of an AIE Flatfile External Data Store Query ? I am using a Like statement but it isn't limiting the key data... Computername like 'ES%' Does anyone see anything wrong with that statement? Computername is coming from the flatfile. It's been selected from the External Data Store Fields. Thanks, Janie <mailto:[EMAIL PROTECTED]> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Important Notice: This e-mail and its contents are subject to the Business Connexion (Pty) Ltd e-mail legal notice available at: http://www.bcx.co.za/disclaimer.htm __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Important Notice: This e-mail and its contents are subject to the Business Connexion (Pty) Ltd e-mail legal notice available at: http://www.bcx.co.za/disclaimer.htm __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
