Title: RE: SELECT NOT WORKING [uv 10 - unix]
I was about to ask if TYPE was indexed? That's also an
obvious one ... if the index has somehow gotten out of sync.
Cheers,
Wol
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of George
GallenSent: 02 February 2004 22:08To
Title: RE: SELECT NOT WORKING [uv 10 - unix]
it's
that step 2 part, that always gets me.
hey..is that like
1.
stop
2.
drop
3.
roll
George
-Original Message-From: Piers Angliss
[mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004
5:11 PMTo: U2 Users Discu
Title: RE: SELECT NOT WORKING [uv 10 - unix]
Work-around :
Stop
Think
Rtfm
Note 2
and 3 are interchangeable
Try 'WITH EVERY TYPE # "CREDIT" ' as Martin
suggests
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Geor
Title: RE: SELECT NOT WORKING [uv 10 - unix]
Use
WITH EVERY TYPE # CREDIT
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of George
GallenSent: Monday, February 02, 2004 4:56 PMTo: 'U2
Users Discussion List'Subject: RE: SELECT N
Title: RE: SELECT NOT WORKING [uv 10 - unix]
YES. That worked.
George
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Monday, February 02, 2004 5:06 PM
>To: U2 Users Discussion List
>Subject: RE: SELECT NOT WORKING [uv 10 - unix]
>
There are 2 problems I have seen in the past (with all versions).
1st, (the simple one)...
check the dictionary item to make sure it is set as multivalue
(for D/I types, this is an "M" in field 6)
---
2nd...
Rec-a credit}nocredit
Rec-b credit
Rec-c nocredit
Select file with fiel
Try SELECT FILE WITH EVERY TYPE # "CREDIT"
Harman Armstrong
[EMAIL PROTECTED]
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
ssage-From: George Gallen
[mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 4:55
PMTo: 'U2 Users Discussion List'Subject: RE: SELECT NOT
WORKING [uv 10 - unix]
Gives the same result as SELECT FILE WITH TYPE =
"CREDIT"
-Original Message-From:
Is it possible that of the 253 records in MYLIST
:
10 have a value of "CREDIT" somewhere in the m/v list in field "TYPE"
all 253 have a value other than "CREDIT" somewhere in the same m/v
list
-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]OnBehalf
Of Georg
Title: RE: SELECT NOT WORKING [uv 10 - unix]
At least this makes sense.
But is there a work around, rather than two selects and a merge.list?
George
>-Original Message-
>From: Martin Phillips [mailto:[EMAIL PROTECTED]]
>Sent: Monday, February 02, 2004 4:51 PM
>
There are 253 items in the list that have something in the type field other
than CREDIT.
There are also 10 items that have CREDIT in that field.
Since it is a multi-valued field, there are items in the list that meet both
sets of criteria (Type not equal to CREDIT and type equal to CREDIT).
Gives
the same result as SELECT FILE WITH TYPE = "CREDIT"
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 4:57
PMTo: U2 Users Discussion ListSubject: Re: SELECT NOT
WORKING [uv 10 - unix]Just curious, does &g
Title: RE: SELECT NOT WORKING [uv 10 - unix]
WHEN Doesn't help. Same thing
>-Original Message-
>From: Jeff Schasny [mailto:[EMAIL PROTECTED]]
>Sent: Monday, February 02, 2004 4:43 PM
>To: U2 Users Discussion List
>Subject: RE: SELECT NOT WORKING [uv 10 - unix]
I suspect that since TYPE is a mutlivalued field, some records have CREDIT
in one value and something else in another value. Given that every record
meets the TYPE # "CREDIT" condition, I would take a careful look at the data
to see if there is a stray value mark in every record resulting in an
ap
Just curious, does
>SELECT FILE WITHOUT TYPE = "CREDIT"
Work?
Bruce M Neylon
Health Care Management Group
George Gallen <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/02/2004 04:41 PM
Please respond to U2 Users Discussion List
To: 'Ardent List' <[EMAIL PROTECTE
Try WHEN insted of WITH
-Original Message-
From: George Gallen [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 2:41 PM
To: 'Ardent List'
Subject: SELECT NOT WORKING [uv 10 - unix]
OKWhat gives.
GET-LIST MYLIST
253 ITEMS SELECTED
>SELECT FILE WITH TYPE # "CREDIT"
253 ITEMS
16 matches
Mail list logo