Mr. Fordham, if you are ever within 500 miles of St. Petersburg
Florida, I owe you beer or dinner or my firstborn or something. That
tiny little change is all I needed. It works. Thank you so much for
your help.
Matt
On Apr 24, 12:15 pm, "Bryan L. Fordham" <[EMAIL PROTECTED]>
wrote:
> [EMAIL PROTECTED] wrote:
> > cursor.execute("""
> > SELECT sports_players.city_id, sports_players.team_id,
> > count(sports_players.team_id) FROM sports_players,
> > sports_mastercitylist
> > WHERE sports_players.city_id=sports_mastercitylist.id
> > AND sports_mastercitylist.cityslug = %s
> > GROUP BY 1, 2
> > ORDER BY 1""" % city)
>
> try changing that last part to "Order by 1 """, [city])
>
> http://www.djangoproject.com/documentation/model-api/#executing-custo...
>
> --B
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---