Problem with raw query and using in

Hello,

wondering if I am doing something wrong or it is a bug, using django
1.5.5, but also tried with 1.6 resulting in the same problem.

When I do the following:

realms=[1]
data = AuctionData.objects.filter(itemid__exact=itemid,realm__in=realms)
data2 = AuctionData.objects.raw('SELECT * FROM auctiondata_auctiondata
WHERE itemid_id=%s AND realm_id in %s ',[itemid,realms])

The first query works as expected, but the 2nd one fails, because the
query ends up as:

SELECT * FROM auctiondata_auctiondata WHERE itemid_id='43552' AND
realm_id in ('1',)

The last comma shouldnt be there, if I use more than 1 value with the
realms variable it works and the last comma isn't there.

Greetings,
Thorsten

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/528767D4.8080709%40gmx.net.
For more options, visit https://groups.google.com/groups/opt_out.