discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Zainub Gaffoor - BCX
Sent: Wednesday, September 10, 2008 1:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: AIE Flatfile External Vendor Query
**
Seems like wildcards are not needed when using the LIKE statement.
In reference
Yeah, I've concluded likewise. Tried the LIKE operator with the
samples loaded on AIE and it didn't work.
Glad u've found a workaround J
Important Notice:
This e-mail and its contents are subject to the Business Connexion (Pty) Ltd
e-mail legal notice available at:
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: arslist@ARSLIST.ORG
Subject: AIE Flatfile External
] On Behalf Of Zainub Gaffoor - BCX
Sent: Tuesday, September 09, 2008 12:43 AM
To: arslist@ARSLIST.ORG
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
Of Janie
Sent: Tuesday, September 09, 2008 10:36 AM
To: arslist@ARSLIST.ORG
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
, September 09, 2008 10:58 AM
To: arslist@ARSLIST.ORG
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
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
7 matches
Mail list logo