newbie: Need Help Moving Data from Kirbybase to Gadfly

[dc]

I have muddle through this and gotten my script to work. Corrected code
attached.

#   get global modules for python
import os
import sys

#get database manager module
from kirbybase import KirbyBase, KBError

# open a database, embedded
db = KirbyBase()
result=db.select('test2.tbl', ['recno'],['*'], returnType='object')

# open Gadfly database for storing data
import gadfly
connection = gadfly.gadfly("subscription", "pvfd_sql")

#connection.startup("subscription", "pvfd_sql")
cursor = connection.cursor()

# Insert all records into SQL Database
for record in result:
   ln=str(record.lastname).strip("'")
   fn=str(record.firstname).strip("'")
   ci=str(record.city).strip("'")
   st=str(record.state).strip("'")
   ad=str(record.address).strip("'")
   zi=str(record.zip).strip("'")
   ph=str(record.phone).strip("'")

   sql = "INSERT INTO addresslist (lastname, firstname,CITY, STATE,
ADDRESS, ZIPCODE, PHONE) VALUES(?,?,?,?,?,?,?)"
   cursor.execute(sql,(ln, fn, ci, st, ad, zi, ph))
   print "adding..."
   connection.commit()
connection.close

#------------------------------------------------------------------------------
#  End of Script
#------------------------------------------------------------------------------