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+unsubscr...@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.

Reply via email to