Oops..hehehe, where in (9046,8479) worked... was using = instead of in...knew I was doing something stupid. Thanks!
Ron Mast Webmaster Truth Hardware Ph: 507-444-4748 Fx: 507-444-5361 www.truth.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Everhart Sent: Wednesday, January 26, 2005 11:48 AM To: [email protected] Subject: Re: simple query hang up Ron, Try this, WHERE CUST IN (9046,8479) OR you could use WHERE Cust = 9046 OR Cust = 8479 But I would recommend the first. Ryan On Wed, 26 Jan 2005 10:54:37 -0600, Ron Mast <[EMAIL PROTECTED]> wrote: > > > Hi All, > > <CFQUERY name="getPRC" datasource="#DSN#"> > > SELECT ITEM, CURR > > FROM PRCL01 > > WHERE CUST = 9046 > > AND CUST = 8479 > > </CFQUERY> > > > > Why does this return 0 records, but separately returns the correct amount of > records. > > > > Using CFServer5.0 > > > > Something simple I'm sure. > > > > > Ron Mast > > Webmaster > > Truth Hardware > > Ph: 507-444-4748 > > Fx: 507-444-5361 > > www.truth.com > > ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
