yeah, I switched it around and still the same results and ContactTypeID is
an interger
I've also tried
Where ContactTypeID=1 and CMvLname Like 'sche%'
and
Where CMvLname Like 'sche%' and ContactTypeID=1
and I've even reenter a 1 into the ContactTypeID field, all with the same
odd results.
I tell you what, this is a real head scratcher...
----- Original Message -----
From: "James Bentley" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, August 14, 2008 3:13 PM
Subject: [RBASE-L] - Re: Odd data results...
Rachel,
what happens if you run:
Where ContactTypeID='1' and CMvLname Like 'sche%'
Also is ContactTypeID a TEXT datatype or an INTEGER datatype
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
--- On Thu, 8/14/08, Rachael Malberg <[EMAIL PROTECTED]>
wrote:
From: Rachael Malberg <[EMAIL PROTECTED]>
Subject: [RBASE-L] - Odd data results...
To: "RBASE-L Mailing List" <[email protected]>
Date: Thursday, August 14, 2008, 2:42 PM
Okay my SQL statement doesn't return all my records and
can't figure why...
When I run the following at the rprompt
R>select
CID,CMvFname,CMvLname,ContactTypeID,ContactTypeStatus from
atvGetContMstrType Where CMvLname Like 'sche%'
I get....
1 MORGAN SCHEDIN
0 A
1 MORGAN SCHEDIN
1 A
74 CHRISTINE SCHEDIN
0 A
1741 KEITH SCHEURING
0 A
1741 KEITH SCHEURING
1 A
2310 ROBERTA SCHEDINE
0 A
2310 ROBERTA SCHEDINE
9 A
2578 DENNIS SCHERER
0 A
2578 DENNIS SCHERER
3 A
3673 MIKE SCHENDZIELOS
0 A
3673 MIKE SCHENDZIELOS
1 A
1741 KEITH SCHEURING
0 A
2310 ROBERTA SCHEDINE
0 A
2578 DENNIS SCHERER
0 A
3673 MIKE SCHENDZIELOS
0 A
then I run this...
R>select
CID,CMvFname,CMvLname,ContactTypeID,ContactTypeStatus from
atvGetContMstrType Where CMvLname Like 'sche%' and
ContactTypeID='1'
and get these...
1741 KEITH SCHEURING
1 A
3673 MIKE SCHENDZIELOS
1 A
but not this one...
1 MORGAN SCHEDIN
1 A
any ideas why?
