Solved

recotd count is 0

Posted on 2004-04-27
6
225 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 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 50 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
key press alert 2 47
Html CheckBox obtain Its Value 5 43
Asp response.write to clients 6 46
SP converting date time to date and time separately 2 38
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

734 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