>
> That looks good. Are you running the app by itself, or launching from
> the Class Designer? If the latter, what directory are you starting from?
>
> -- Ed Leafe
The main app directory is
/home/david/dabu_quickstart
I start it with python main.py
dabo_quickstart $ ls
biz db main.py main.py~ reports resources test ui
I got it to work but I had to manually put some info into the database;
#!/usr/bin/python
import MySQLdb
import MySQLdb.cursors
conn = MySQLdb.Connect(
host='localhost', user='root',
passwd='atlantic', db='daboconsult',compress=1,
cursorclass=MySQLdb.cursors.DictCursor) # <- important
cursor = conn.cursor()
cursor.executemany(
"""INSERT INTO clients (clientname, rate, attn, street1, street2,
city, stateprov, postalcode)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s)""", [("David Abbott", "15",
"David", "street1", "street2", "city", "FL", "33309" )])
cursor.execute("SELECT * FROM clients")
rows = cursor.fetchall()
cursor.close()
conn.close()
for row in rows:
print row['clientname'], row['rate'], row['attn'], row['street1'],
row['street2'], row['city'], row['stateprov'], row['postalcode'] # bingo!
But I have some work to do, alot of bugs. First I need to figure out how
to create a new record. I can edit existing records but need a way to
create a new one. I will play around with it and be back, thanks again.
-david
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
