On Jun 4, 2005, at 9:24 AM, Jeff Elkins wrote:
> I'm writing a small wxpython app to display and update a dataset.
Have you looked at Dabo (URL is in my sig)? You can create an app to
select, edit and update a MySQL database in about 30 seconds. It also
wraps wxPython to make creating c
Thanks for the replies!
I went ahead and used the fetchall() approach and work with the array,
writing changes back to the database. It's working fine.
Jeff
--
http://mail.python.org/mailman/listinfo/python-list
Am Samstag, 4. Juni 2005 17:23 schrieb Jeff Elkins:
> Within this same app, I've got a search function working, but I need the
> rownumber when a record is fetched.
>
> sql = """select * from address where %s = %%s""" % arg1.lower()
> cursor.execute(sql, (arg2,))
> item =
Jeff Elkins wrote:
> On Saturday 04 June 2005 09:24 am, Jeff Elkins wrote:
...
>>Now, how do I step through the dataset one row at a time? My form has
>>'next' and 'back' buttons, and I'd like them to step forward or back,
>>fetching the appropriate row in the table. I've tried setting
>>cursor.r
On Saturday 04 June 2005 09:24 am, Jeff Elkins wrote:
> I'm writing a small wxpython app to display and update a dataset. So far, I
> get the first record for display:
>
> try:
> cursor = conn.cursor ()
> cursor.execute ("SELECT * FROM dataset")
> item = cursor.fetchone ()
>
> No
Jeff Elkins wrote:
> I'm writing a small wxpython app to display and update a dataset. So far, I
> get the first record for display:
>
> try:
> cursor = conn.cursor ()
> cursor.execute ("SELECT * FROM dataset")
> item = cursor.fetchone ()
>
> Now, how do I step through the dat
Jeff Elkins wrote:
> I'm writing a small wxpython app to display and update a dataset. So far,
> I get the first record for display:
>
> try:
> cursor = conn.cursor ()
> cursor.execute ("SELECT * FROM dataset")
> item = cursor.fetchone ()
>
> Now, how do I step through the dat
I'm writing a small wxpython app to display and update a dataset. So far, I
get the first record for display:
try:
cursor = conn.cursor ()
cursor.execute ("SELECT * FROM dataset")
item = cursor.fetchone ()
Now, how do I step through the dataset one row at a time? My form has
