That's the problem...i'm not getting an error at all...its just not working. If I eliminate the part about the badge number, I get a query of length zero. (and I know that is wrong). Any suggestions?
-----Original Message----- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 11:04 AM To: SQL Subject: Re: oops! Whats the error you are getting? SELECT CH_Employee_ATT_feb.ISP_User_Last_Name, CH_Employee_ATT_feb.ISP_User_First_Name, CH_Employee_ATT_feb.ATT_Usage_feb.Invalid_User, Valid_Employees.Last_Name, Valid_Employees.First_Name FROM CH_Employee_ATT_feb, Valid_Employees WHERE CH_Employee_ATT_feb.ISP_Employee_Badge_Number = Valid_Employees.[Badge Number] OR ( CH_Employee_ATT_feb.ISP_User_Last_Name = Valid_Employees.Last_Name AND CH_Employee_ATT_feb.ISP_User_First_Name = Valid_Employees.First_Name ) ----- Original Message ----- From: "Conaway, Amy C" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Tuesday, August 05, 2003 10:50 AM Subject: oops! > ..it would help if I pasted the code.... > > SELECT CH_Employee_ATT_feb.ISP_User_Last_Name, CH_Employee_ATT_feb.ISP_User_First_Name, CH_Employee_ATT_feb.ATT_Usage_feb.Invalid_User, Valid_Employees.Last_Name, Valid_Employees.First_Name > FROM CH_Employee_ATT_feb, Valid_Employees > WHERE CH_Employee_ATT_feb.ISP_Employee_Badge_Number = Valid_Employees.[Badge Number] OR (CH_Employee_ATT_feb.ISP_User_Last_Name = Valid_Employees.Last_Name AND CH_Employee_ATT_feb.ISP_User_First_Name = Valid_Employees.First_Name) ; > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
