[Skip]
> I use it all the time. For example, to build up (what I consider to be)
>readable SQL queries:
>
> rows = self.executesql("select cities.city, state, country"
> " from cities, venues, events, addresses"
> " where cities.city like %s"
> " and events.active = 1"
> " and venues.address = addresses.id"
> " and addresses.city = cities.id"
> " and events.venue = venues.id",
> (city,))
I find that style hard to maintain. What is the advantage over multi-line
strings?
rows = self.executesql('''
select cities.city, state, country
from cities, venues, events, addresses
where cities.city like %s
and events.active = 1
and venues.address = addresses.id
and addresses.city = cities.id
and events.venue = venues.id
''',
(city,))
Raymond
_______________________________________________
Python-Dev mailing list
Python-Dev@python.org
http://mail.python.org/mailman/listinfo/python-dev
Unsubscribe:
http://mail.python.org/mailman/options/python-dev/archive%40mail-archive.com
