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
#------------------------------------------------------------------------------
--
http://mail.python.org/mailman/listinfo/python-list
