RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-03 Thread Anthony Youngman
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread Piers Angliss
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread KBessel
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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] >

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread Glenn W. Paschal
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread harman
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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:

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread Piers Angliss
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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 >

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread KBessel
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).

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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]

Re: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread Martin Phillips
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

Re: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread BNeylon
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread Jeff Schasny
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