Hi,
Every time you use the error object, you need to include this line at the top of the ASP page: ON ERROR RESUME NEXT
After every use of the error object, before using it again you need to clear the error object with Err.Clear()
Hi,
You could try this...
Let's say, A is the categories table ('cat_id' as PK)
B is the classifieds table ('class_id' as PK and 'cat_id' as FK to A)
select A.cat_id, count(B.class_id) from A, B where A.cat_id (+) = B.cat_id group by B.cat_id, B.class_id order by B.class_id
Hope this helps...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.