This is a mailing list for developing of django itself. For usage of django please use the django-user mailing list.
Jorge On Jul 17, 2013, at 4:21 PM, spondbob squelpen wrote: > I have problem in django using query statement "LIKE %s%" with > Model.objects.raw(). I guess the problem is on '%' character but i don't know > where is it. Here's my model's code: > > def listInRange(self, placeLat, placeLng, typeId, range, placeTag): > tags = '' > if placeTag: > tags = " AND (placeTag LIKE '%" + "%' OR placeTag LIKE > '%".join(placeTag.split(',')) + "%')" > > query = "SELECT *, \ > ( \ > 6371000 * \ > acos( \ > cos( radians(%s) ) * \ > cos( radians(placeLat) ) * \ > cos( radians(placeLng) - radians(%s) ) + \ > sin( radians(%s) ) * \ > sin( radians(placeLat) ) \ > ) \ > ) AS placeDistance, \ > COUNT(r.reviewId) as placeReviews, \ > > (SUM(r.reviewPointPrice)/COUNT(r.reviewId)+SUM(r.reviewPointService)/COUNT(r.reviewId)+SUM(r.reviewPointLocation)/COUNT(r.reviewId)+SUM(r.reviewPointCondition)/COUNT(r.reviewId)+SUM(r.reviewPointComfort)/COUNT(r.reviewId))/5 > AS averagePoint \ > FROM place_place p \ > LEFT JOIN review_review r \ > ON r.reviewPlace_id = p.placeId\ > WHERE placeType_id = %s %s \ > GROUP BY p.placeId \ > HAVING placeDistance < %s \ > ORDER BY placeDistance" > > return Place.objects.raw(query, [placeLat, placeLng, placeLat, > typeId, tags, range]) > > If placeTag is not empty, then it will added to the WHERE condition. When the > placeTag is empty there's no such problem, but when placeTag is not empty i > got this error : > > Warning: Truncated incorrect DOUBLE value: '1 AND (placeTag LIKE '%cafe%' > OR placeTag LIKE '%pub%')' > > I think python make '1 AND (placeTag LIKE '%cafe%' OR placeTag LIKE '%pub%')' > as the value for placeType_id. How can i make the value of placeType_id=1 and > add the AND statement? What's the better way to write the sql statement using > Model.objects.raw() with 'like' statement? > > -- > You received this message because you are subscribed to the Google Groups > "Django developers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-developers+unsubscr...@googlegroups.com. > To post to this group, send email to django-developers@googlegroups.com. > Visit this group at http://groups.google.com/group/django-developers. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "Django developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-developers+unsubscr...@googlegroups.com. To post to this group, send email to django-developers@googlegroups.com. Visit this group at http://groups.google.com/group/django-developers. For more options, visit https://groups.google.com/groups/opt_out.