var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query returns inconsistent results
I've written a simple query to return details on a garment (for use in an 'ordering' website using ASP).
SELECT distinct season, style, cloth, name, Sketch_big, style_id, Sizes, fabric, prod_group
WHERE prod_group = 'belts'
(the prod_group will be variable but i've been testing using belts).
I know there should be 26 results returned. However, when i run the query it seems to be entirely random as to how many results are returned. (same problem happens using other garments)
It's doing my head in!
The table i am getting the result from - 'colours' is another query. Could this be where my problem lies?
I'd be grateful for any help!
Re: Query returns inconsistent results
Can you post the source of the colours query as well?
I can't see anything obviously wrong with the SQL you've already posted.