> i want this simple query to show users who have not voted.
> it is not working the way i think it should.
> i have tried putting a DISTINCT on tbl_Employee.EmployeeID.
>
> if you have any suggestions of somthing i have over looked i would
> appreciate it.
> i am using access.
>
> <cfquery name="noVote">
> SELECT DISTINCT tbl_Employee.EmployeeID, FirstName, LastName
> FROM tbl_Awards, tbl_Employee
> WHERE tbl_Employee.EmployeeID<>tbl_Awards.EmployeeID
> AND LastName NOT LIKE '%Conf%'
> AND LastName NOT LIKE '%Mailroom%'
> AND LastName NOT LIKE '%XEROX%'
> AND LastName NOT LIKE '%_NoUser%'
> ORDER BY LastName DESC
> </cfquery>
>
>
> <CFOUTPUT QUERY="noVote">
> <tr bgcolor="#IIF(CurrentRow MOD 2, DE('FFFFFF'), DE('D5D5D5'))#">
> <td width="50%" height="17">#noVote.FirstName#
> #noVote.LastName# </td>
> <td width="50%" height="17"> </td>
> </tr>
> </cfoutput>
Certain flavors of SQL don't like <> as not equal
I perfer to use "NOT tbl_Employee.EmployeeID=tbl_Awards.EmployeeID" as this
says basically what it does (even though the logic can seem a little
backwards)
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
