[Zope] Problem with Z SQL Method

I've created several Z SQL methods and they are running fine (connecting to mySQL). Now one that I'm working on gives a exceptions.KeyError: unhandled error. I don't believe it's a problem with the sql syntax because I can copy and paste the sql directly into the mysql client and it runs fine. Any suggestions? thanks, Kevin