Re: queries about exceptions(newbie)

2010-06-04 Thread Payal
On Thu, Jun 03, 2010 at 11:42:16PM -0700, Chris Rebert wrote: > >>> try: > ... x[1] > ... except IndexError as e: > ... print "Got error:", e.args[0] # grab the error message > ... > Got error: list index out of range Thanks a lot. This example solved what the tutorial could not. With war

Re: queries about exceptions(newbie)

2010-06-03 Thread Chris Rebert
On Thu, Jun 3, 2010 at 11:31 PM, Payal wrote: > Hi all, > I am trying to learn exceptions and have few small doubts from > http://docs.python.org/tutorial/errors.html > There are many statements there of the form, > > ... except Exception as inst: >        do something > > ... except ZeroDivisionE

Re: Queries

2009-02-28 Thread mmcclaf
So basically you are complaining that groups don't pick up post by GMail users? As for the SQL thing, you still don't see how I am linking this to SQL? I have to make in your terms: a textual representation of the statements I'd make in SQL. The statement I made with the bold SELECT, etc, replace

Re: Queries

2009-02-27 Thread Steve Holden
Dennis Lee Bieber wrote: > On Fri, 27 Feb 2009 15:39:13 -0800 (PST), mmcclaf > declaimed the following in gmane.comp.python.general: > >> This came in the Python groups, and I put one up in the database >> group, since I will later have to use Python to access the SQL file, [...] >> The relationa

Re: Queries

2009-02-27 Thread mmcclaf
This came in the Python groups, and I put one up in the database group, since I will later have to use Python to access the SQL file, so therefore tackling one thing at a time. Also, there were no answers that were coming up in the .database group. On top of that: >Really? You can have shi

Re: Queries

2009-02-27 Thread Steve Holden
Dennis Lee Bieber wrote: [...] > {Oh, and since I saw, at work, a later post with a bunch of nested UNION > statements: UNION requires all the tables to have the same number/type > of columns -- you don't have that} A rather fine point, but technically all that's required is the the united *querie

Re: Queries

2009-02-26 Thread mmcclaf
Another problem with this assignment... I have to list all the ships mentioned in the database. All the ships may not appear in the Ships relations... I said the following in algebraic expression SELECT name(Ships UNION (SELECT ship (Outcome UNION(SELECT class (Classes))) Would that work? -- http

Re: Queries

2009-02-26 Thread mmcclaf
On Feb 26, 7:51 am, Steve Holden wrote: > Murray wrote: > > [top-posting corrected] > > > > > -Original Message- > > From: Gary Herron [mailto:gher...@islandtraining.com] > > Sent: Thursday, February 26, 2009 1:46 AM > > To: mmcclaf; pytho

Re: Queries

2009-02-26 Thread Bret Fledderjohn
2009/2/26 Steve Holden > Murray wrote: > [top-posting corrected] > > > -Original Message- > > From: Gary Herron [mailto:gher...@islandtraining.com] > > Sent: Thursday, February 26, 2009 1:46 AM > > To: mmcclaf; python-list@python.org > > Subject: Re

Re: Queries

2009-02-26 Thread Steve Holden
Murray wrote: [top-posting corrected] > -Original Message- > From: Gary Herron [mailto:gher...@islandtraining.com] > Sent: Thursday, February 26, 2009 1:46 AM > To: mmcclaf; python-list@python.org > Subject: Re: Queries > > mmcclaf wrote: >> I have to make

RE: Queries

2009-02-26 Thread Murray
, 2009 1:46 AM To: mmcclaf; python-list@python.org Subject: Re: Queries mmcclaf wrote: > I have to make some queries for 4 tables I have. The following > relations are: > > Classes(class, type, country, numGuns, bore, displacement) > Ships (name, class, launched) > Battles (name

Re: Queries

2009-02-25 Thread Gary Herron
mmcclaf wrote: I have to make some queries for 4 tables I have. The following relations are: Classes(class, type, country, numGuns, bore, displacement) Ships (name, class, launched) Battles (name, date) Outcomes (ship, battle, result) The three queries I'm stuck on are the following: 1. Find