Thanks for all the info about getting the record names. I used the names function and it works great!! If anyone is interested, I searched for dictionaries in zope.org and found a nice link explaining the ZSQL results class. The results class is the object returned from a ZSQL method. The link is http://www.zope.org/Members/spinwing/ZSQL_Results