Rachel Step 1. try Where ContactTypeID=1 only and see what you get. 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] - Re: Odd data results... > To: "RBASE-L Mailing List" <[email protected]> > Date: Thursday, August 14, 2008, 3:25 PM > 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? > > > > > > > > > >
