Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by rohitbd
-
Err.Number Problem
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()- rohitbd
- Post #2
- Forum: Microsoft: ASP (Active Server Pages)
-
Urgent : SQL Query Problem
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...- rohitbd
- Post #4
- Forum: Microsoft: ASP (Active Server Pages)
