10 minutes ago :)
Thanks!
Robert Bailey
Aesir Network Technologies
Direct: (727) 489-2604
Main: (903) 238-8211
Support: (903) 238-8212
Toll Free: (877) 238-8211
Fax: (903) 238-8251
-----Original Message-----
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Monday, April 12, 2004 6:48 AM
To: CF-Talk
Subject: RE: SQL Query Problems
> I take out the or clause and use either one of those
> product_id's I get 1 record back, this should only return 2
> records, it returns 1 for id "7000" and 12 for "6868"
Have you confirmed that only one record is returned when you use ONLY ID
7000 and only one record is returned when you use ONLY ID 6868? Start there.
If both queries individually return the right amount of records, you may
have a join issue... As in there might not be any product images, or more
than one product image with an associated ID, etc...
HTH,
Mike
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
