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
