where do i put those double percentage? like this?
tags = " AND (placeTag LIKE '%%" + "%%' OR placeTag LIKE
'%%".join(placeTag.split(',')) + "%%')"
but still got the same error:
Warning: Truncated incorrect DOUBLE value: '1 AND (placeTag LIKE
'%%test%%')'
On Wednesday, July 17, 2013 9:47:25 PM UTC+7, [email protected] wrote:
>
> On Wed, Jul 17, 2013 at 8:24 AM, spondbob squelpen
> <[email protected]<javascript:>>
> 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: '1AND (placeTag LIKE
> '%cafe%'
> > OR placeTag LIKE '%pub%')'
> >
> > I guess 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 need '%%' when you want to end up with '%'
>
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users.
For more options, visit https://groups.google.com/groups/opt_out.
