Re: [Tutor] Tutor Digest, Vol 16, Issue 7

2005-06-02 Thread Greg Lindstrom
>data = "">>data['start_date'] = '2005-6-2'>data['last_name'] = 'Johnson'>>query = ''' >SELECT *>  FROM my_table> WHERE date >= '%(start_date)s'>   AND last_name = '%(last_name)s'>''' % data>results = my_database.Execute(query)First up. This is a "bad idea". It may be ok now, as lo

Re: [Tutor] Building an SQL query

2005-06-02 Thread Greg Lindstrom
Hmm, I dunno ADOpy but assume it somehow miraculously turns your dataset into a dictionary of some sort? How it guesses which order the SELECT will return the fields is a mystery to me, but maybe it hasknowledge of the Postgres hashing function or somesuch.   Yeah.  I used to do it by hand by look

Re: [Tutor] quick PIL question

2005-06-02 Thread Tim Peters
[Max Noel] > ... > This is where the palette comes into play. Each 256-color image > has a palette, which is basically an array of length 256, where each > element is a (24-bit RGB) color. The color data for each pixel in the > image is actually an index in this array. Adding a bit of detail,

Re: [Tutor] quick PIL question

2005-06-02 Thread Terry Carroll
On Thu, 2 Jun 2005, Max Noel wrote: [explanation snipped] > Makes sense? Yes. Thanks very much. I think the problem is the the PIL documentation (reasonably) assumes that the reader already understands all the structures used in the imaging it supports; it just explains how PIL gives a

Re: [Tutor] quick PIL question

2005-06-02 Thread Max Noel
On Jun 2, 2005, at 23:39, Terry Carroll wrote: > The palette mode ("P") uses a colour palette to define the actual > colour for each pixel. > > > > Not sure what that means, exactly, but it looks like im.palette > will get > the palette of a a P-mode image, and im.putpalette will change

Re: [Tutor] quick PIL question

2005-06-02 Thread Terry Carroll
On Thu, 2 Jun 2005, D. Hartley wrote: > What does it mean if my image mode is "P"? In the documentation, it > says "typical values are '1', 'L', 'RGB', 'CMYK.'" (it's a gif, if > that's important) That's really weird. It does say that (in the description of im.mode, where you'd expect it). But

Re: [Tutor] Building an SQL query

2005-06-02 Thread Roger Merchberger
Rumor has it that Alan G may have mentioned these words: >Hmm, I dunno ADOpy but assume it somehow miraculously turns your data >set into a dictionary of some sort? I dunno ADOpy, but the pg module for PostgreSQL can return a list of dictionaries from a query. >>> import pg >>> pg.set_defuser

Re: [Tutor] Py2exe Problem

2005-06-02 Thread jfouhy
Quoting Alberto Troiano <[EMAIL PROTECTED]>: > I'm having a problem with Py2exe. > I created the executable but when I try to execute it it gives the > following > error: > > Traceback (most recent call last): > File "NovusExtension.pyw", line 8, in ? > File "Pmw\__init__.pyc", line 28, in ? >

Re: [Tutor] Building an SQL query

2005-06-02 Thread Alan G
> > SELECT * does not normally guarantee anything about the order of fields > > returned, so if the table gets an extra field added you might find the order > > I'm using SELECT * specifically for this reason! I have the query and > customer specific data layouts stored in a database and am using A

Re: [Tutor] Building an SQL query

2005-06-02 Thread Greg Lindstrom
On 6/2/05, Alan G <[EMAIL PROTECTED]> wrote: Its a really bad idea to use SELECT * FROM in production code.There are two main reasons:1) If the database structure changes your code is likely to break since SELECT * does not normally guarantee anything about the order of fields returned, so if the t

Re: [Tutor] Building an SQL query

2005-06-02 Thread Lee Harr
>data = {} >data['start_date'] = '2005-6-2' >data['last_name'] = 'Johnson' > >query = ''' >SELECT * > FROM my_table > WHERE date >= '%(start_date)s' > AND last_name = '%(last_name)s' >''' % data >results = my_database.Execute(query) First up. This is a "bad idea". It may be ok

Re: [Tutor] Building an SQL query

2005-06-02 Thread Alan G
> I am building a query to hit a Postgres (8.0.1) database > from Python (4.2.1) on Linux. Here's how I've been doing > it for the past year or so: > ... > query = ''' > SELECT * > FROM my_table > Its a really bad idea to use SELECT * FROM in production code. There are two main reasons: 1) I

[Tutor] Connect to Apache Derby databases using Python

2005-06-02 Thread Bob Gibson
For Your Information / Enjoyment / Entertainment / Education... (whatever): http://www.ibm.com/developerworks/db2/library/techarticle/dm-0505gibson Bob ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor

[Tutor] quick PIL question

2005-06-02 Thread D. Hartley
What does it mean if my image mode is "P"? In the documentation, it says "typical values are '1', 'L', 'RGB', 'CMYK.'" (it's a gif, if that's important) Thanks! :) ~Denise ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/t

Re: [Tutor] Strange IndexError

2005-06-02 Thread Danny Yoo
On Thu, 2 Jun 2005, Willi Richert wrote: > my app is a Pyrobot (http://emergent.brynmawr.edu/~dblank/pyro/) > simulation which connects to PlayerStage (playerstage.sf.net) to > simulate three Pioneer robots. These are controlled using NeedBrain.py. > In parallel to the three NeedBrains there is

Re: [Tutor] How interacts Python with .exe files

2005-06-02 Thread Bob Gailer
At 07:56 AM 6/2/2005, Xabier Gonzalez wrote: I wanted to know how can I use in Python the inputs and the outputs of an .exe file. Take a look at the popen2 module. Bob Gailer mailto:[EMAIL PROTECTED] 510 558 3275 home 720 938 2625 cell ___ Tutor mai

Re: [Tutor] Building an SQL query

2005-06-02 Thread Bob Gailer
At 06:48 AM 6/2/2005, Greg Lindstrom wrote: Hello- I am building a query to hit a Postgres (8.0.1) database from Python (4.2.1) on Linux.  Here's how I've been doing it for the past year or so: data = ""> data['start_date'] = '2005-6-2' data['last_name'] = 'Johnson' query = '''    SELECT *

[Tutor] Py2exe Problem

2005-06-02 Thread Alberto Troiano
Hey I'm having a problem with Py2exe. I created the executable but when I try to execute it it gives the following error: Traceback (most recent call last): File "NovusExtension.pyw", line 8, in ? File "Pmw\__init__.pyc", line 28, in ? WindowsError: [Errno 3] El sistema no puede hallar la r

[Tutor] How interacts Python with .exe files

2005-06-02 Thread Xabier Gonzalez
I wanted to know how can I use in Python the inputs and the outputs of an .exe file. Maybe the question is too simple, but I´m new in Python and I have not too much experience in programming (basic C++ knowledge). Xabier Gonzalez (Spain) ___ Tutor ma

[Tutor] Building an SQL query

2005-06-02 Thread Greg Lindstrom
Hello- I am building a query to hit a Postgres (8.0.1) database from Python (4.2.1) on Linux.  Here's how I've been doing it for the past year or so: data = ""> data['start_date'] = '2005-6-2' data['last_name'] = 'Johnson' query = '''    SELECT * FROM my_table     WHERE date >= '%(start_da

Re: [Tutor] Looking for HOWTO's

2005-06-02 Thread Marco Scheidhuber
hi joseph, Joseph Quigley wrote: > PS> I wouldn't mind /any/ Python HOWTO or tutorial google is your friend ;-) Your first tutorial should be http://python.org/doc/2.4.1/tut/tut.html or maybe http://honors.montana.edu/~jjc/easytut/easytut/ and a search for "image reader" python gives e.g. ht

[Tutor] Looking for HOWTO's

2005-06-02 Thread Joseph Quigley
Hi, I could use some howto's or tutorials in python, on how to build an image reader (like: Kview, or Kodak's Easy Share Software). I searched Google but can't find anything (I also have pay-by-the-minute dial up so I don't surf much) I know it's reinventing the wheel, but, I just want to learn

Re: [Tutor] Strange IndexError

2005-06-02 Thread Willi Richert
Hi, my app is a Pyrobot (http://emergent.brynmawr.edu/~dblank/pyro/) simulation which connects to PlayerStage (playerstage.sf.net) to simulate three Pioneer robots. These are controlled using NeedBrain.py. In parallel to the three NeedBrains there is one MonitorBrain running for some managemen