I could be misunderstanding what you're doing, but if CUST is a field in your table, and it only holds one value, you'll need to use OR instead of AND. A single field could never simultaneously have two values.
Matt 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 > > -- Matt Woodward [EMAIL PROTECTED] http://www.mattwoodward.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
