Walking through a mysql db

2005-06-04 Thread Jeff Elkins
'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.rownumber by incrementing it prior to the fetchone() w/o effect. Thanks for any pointers. Jeff Elkins -- http://mail.python.org/mailman/listinfo

Re: Walking through a mysql db

2005-06-04 Thread Jeff Elkins
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 () Now, how do

Re: Walking through a mysql db

2005-06-04 Thread Jeff Elkins
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

Re: xml processing

2005-06-02 Thread Jeff Elkins
On Wednesday 01 June 2005 11:01 am, Steven Bethard wrote: If you're not committed to pyxml, you might consider using ElementTree: http://effbot.org/zone/element-index.htm I find it *way* easier to work with. Thanks. I've installed it and am experimenting. --

xml processing

2005-06-01 Thread Jeff Elkins
into an array. 2. Perform any edit operations within the array. 3. Write out a finished xml file from the array when I'm done. Is this reasonable? Better, smarter ways to accomplish this? Thanks for any advice. Jeff Elkins -- http://mail.python.org/mailman/listinfo/python-list

Re: xml processing

2005-06-01 Thread Jeff Elkins
On Wednesday 01 June 2005 09:51 am, Magnus Lycka wrote: Jeff Elkins wrote: I've like to use python to maintain a small addressbook which lives on a Sharp Zaurus. This list will never grow beyond 200 or so entries. I've installed pyxml. Speaking generally, given a wxpython app to do data

Re: SQL Query via python

2005-05-21 Thread Jeff Elkins
On Saturday 21 May 2005 04:56 am, Heiko Wundram wrote: Am Samstag, 21. Mai 2005 06:54 schrieb Sakesun Roykiattisak: Try cursor.execute ( SELECT name, month, day ,category, city FROM bday WHERE %s = %s %(arg1,arg2)) *argh* You don't do any quoting of SQL-parameters, and

Re: SQL Query via python

2005-05-21 Thread Jeff Elkins
On Saturday 21 May 2005 01:32 pm, Dennis Lee Bieber wrote: On Fri, 20 May 2005 23:57:01 -0400, Jeff Elkins You have to remember that .execute(), using the (template, (arg...)) format, is designed to apply suitable quoting to the arguments. It does not parse the SQL to determine if arguments

Re: passing arguments

2005-05-20 Thread Jeff Elkins
On Friday 20 May 2005 06:46 pm, James Stroud wrote: import sys try: arg1 = sys.argv[1] except IndexError: print This script takes an argument, you boob! sys.exit(1) OR, way better: See the optparse module. On Friday 20 May 2005 03:26 pm, Jeff Elkins wrote: I'm sure

Re: Finding startup files

2005-05-12 Thread jeff elkins
On Thursday 12 May 2005 05:24 am, Mike Meyer wrote: jeff elkins [EMAIL PROTECTED] writes: On Wednesday 11 May 2005 04:44 pm, Grant Edwards wrote: On 2005-05-11, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: The following script demonstrates a method that should work for you. I believe

Re: HELP Printing with wxPython

2005-05-12 Thread jeff elkins
On Thursday 12 May 2005 04:56 am, Mike Meyer wrote: James Carroll [EMAIL PROTECTED] writes: If you are doing this just for yourself, and you know you have a printer that will really print just the plain text when you send it plain text (like a dot matrix printer from the early 90s) then you

Finding startup files

2005-05-11 Thread jeff elkins
I'm creating an app that relies on a configuration file at launch. The file will always exist in the app's installation directory, but I have no control over where that might be. Is there an OS-independent way that I can instruct the app to look in it's home directory for startup files?

Re: Finding startup files

2005-05-11 Thread jeff elkins
On Wednesday 11 May 2005 04:32 pm, [EMAIL PROTECTED] wrote: The following script demonstrates a method that should work for you. I believe it is entirely cross-platform. #! /usr/bin/python import sys import os print os.path.abspath(os.path.dirname(sys.argv[0])) Works perfectly, thanks

Newbie: saving dialog variables

2005-05-07 Thread jeff elkins
Howdy, I've written a program that calls an imported dialog to gather some needed input. What's the common method for passing that data back to the caller? I've tried a 'return data' prior to self.Close() ... all that happens then is the dialog won't close. I'm sure this is obvious, but this

Re: Newbie: saving dialog variables

2005-05-07 Thread jeff elkins
On Saturday 07 May 2005 01:24 pm, jeff elkins wrote: Howdy, I've written a program that calls an imported dialog to gather some needed input. What's the common method for passing that data back to the caller? I've tried a 'return data' prior to self.Close() ... all that happens

Re: Newbie: saving dialog variables

2005-05-07 Thread jeff elkins
On Saturday 07 May 2005 02:34 pm, Jeremy Bowers wrote: On Sat, 07 May 2005 13:24:34 +, jeff elkins wrote: Howdy, I've written a program that calls an imported dialog to gather some needed input. What's the common method for passing that data back to the caller? I've tried a 'return

Re: Newbie: saving dialog variables

2005-05-07 Thread jeff elkins
On Saturday 07 May 2005 04:39 pm, Jeremy Bowers wrote: OK, I can't quite directly run this, but assuming you're trying to get the user to enter some text into the text control, you should be able to add print dlg.venttypeText.GetValue() to print what the user entered; this comes

Re: Which IDE is recommended?

2005-04-27 Thread jeff elkins
On Wednesday 27 April 2005 01:16 pm, monkey wrote: Read through python site for programming tool, really plenty of choices :-) (For c++, I just can't breath with very very limited choices) Tried Spe, it come with wxGlade built-in very nice(is Spe still actively develop?). But seem that Boa

Re: GUI woes

2005-04-24 Thread jeff elkins
On Sunday 24 April 2005 03:11 am, Roger Binns wrote: jeff elkins [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] under debian sid, I installed (via apt-get) the various wxpython stuff available.: libwxgtk2.4-python libwxgtk2.5.3-python python-opengl python-pythoncard

Re: GUI woes

2005-04-24 Thread jeff elkins
On Sunday 24 April 2005 02:07 am, Kartic wrote: Jeff - Could you please post your code? From what you have posted it looks like your MyFrame class does not inherit from wx.Frame. Thanks Kartic. That test.py was from the wxpython download site. --

Re: GUI woes

2005-04-24 Thread jeff elkins
On Sunday 24 April 2005 10:41 am, jeff elkins wrote: On Sunday 24 April 2005 03:11 am, Roger Binns wrote: You have a mixture of different versions of wxPython in there. Thanks. I'll see if I can delete/reinstall and fix things. Fixed and thanks for the clue :) Jeff -- http

GUI woes

2005-04-23 Thread jeff elkins
Howdy, This may not belong here, if so apologies... I'm a python newbie, but have completed a console app that I'd like to run under X. Reading recent postings here, wxpython seemed a reasonable choice so under debian sid, I installed (via apt-get) the various wxpython stuff available.: