Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

recotd count is 0

Posted on 2004-04-27
6
Medium Priority
?
233 Views
Last Modified: 2012-05-04
How can i show  0 count
if EmpCount = 0

My query skips if count is 0

sql = "SELECT count([Devlopment].empid) As EmpCount,[Course Titles].Title,[Course Titles].Title FROM [Course Titles] INNER JOIN Devlopment ON [Course Titles].ID = Devlopment.TitleID WHERE Devlopment.plan=True group by [Course Titles].Title"

    Set rs = Server.CreateObject("ADODB.Recordset")
    rs.Open sql, conn, 3, 3
   do while not re.eof

example

Titles   EmpCount
  35      3
  10      0
  17      1

0
Comment
Question by:alberte
3 Comments
 
LVL 12

Expert Comment

by:ill
ID: 10929063
sql = "SELECT count([Devlopment].empid) As EmpCount,[Course Titles].Title,[Course Titles].Title FROM [Course Titles] LEFT JOIN Devlopment ON [Course Titles].ID = Devlopment.TitleID WHERE Devlopment.plan=True group by [Course Titles].Title"
0
 

Author Comment

by:alberte
ID: 10929172
I got
Syntax error in JOIN operation.

/school/media/admin/planned/planned.asp, line 36
0
 
LVL 6

Accepted Solution

by:
Lord_McFly earned 200 total points
ID: 10929490
SELECT COUNT([Development].empid) AS EmpCount, [Course Titles].Title
FROM [Course Titles] LEFT OUTER JOIN Development ON Development.TitleID = [Course Titles].ID
WHERE Development.plan = True
GROUP BY [Course Titles].Title
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses
Course of the Month13 days, 11 hours left to enroll

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question