I've tried the debugger but i have no idea how to use it to find my problem. in Pdb console i've tried check any variable value and everything seems fine
On Wednesday, July 17, 2013 10:34:39 PM UTC+7, larry....@gmail.com wrote: > > On Wed, Jul 17, 2013 at 9:28 AM, spondbob squelpen > <babib...@gmail.com<javascript:>> > wrote: > > sorry i'm new with django, could u please tell me how to use the > debugger? > > In your python code, add this "import pdb; pdb.set_trace()' at the > place you want the breakpoint. > > Then run: > > python manage.py runserver > > Then go to your web page that will cause your code to be invoked, but > add :8000 to the address (e.g. http://127.0.0.1:8000/...) > > Then when it hits your breakpoint you can set other breakpoints, print > out variables, step though your program, etc. > > http://docs.python.org/2/library/pdb.html > > > On Wednesday, July 17, 2013 10:17:10 PM UTC+7, Larry....@gmail.comwrote: > >> > >> On Wed, Jul 17, 2013 at 9:15 AM, spondbob squelpen <babib...@gmail.com> > > >> wrote: > >> > the '1' is coming from typeId, so the WHERE condition must be look > like: > >> > WHERE placeType_id=1 AND (placeTag LIKE '%test%') > >> > > >> > print out tags: > >> > AND (placeTag LIKE '%test%') > >> > > >> > i have tried your solution by adding double percentage but still got > >> > same > >> > error > >> > >> Like I said, use the debugger. > >> > >> > > >> > On Wednesday, July 17, 2013 10:04:48 PM UTC+7, larry....@gmail.com > >> > wrote: > >> >> > >> >> On Wed, Jul 17, 2013 at 8:58 AM, spondbob squelpen < > babib...@gmail.com> > >> >> wrote: > >> >> > 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%%')' > >> >> > >> >> Where is the '1' coming from? I'd set a breakpoint here and run the > >> >> development server and see exactly what is going on. Print out the > >> >> tags and query, and if necessary step into Place.objects.raw. > >> >> > >> >> > > >> >> > On Wednesday, July 17, 2013 9:47:25 PM UTC+7, larry....@gmail.com > >> >> > wrote: > >> >> >> > >> >> >> On Wed, Jul 17, 2013 at 8:24 AM, spondbob squelpen > >> >> >> <babib...@gmail.com> > >> >> >> 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 django-users...@googlegroups.com. > >> >> > To post to this group, send email to django...@googlegroups.com. > >> >> > Visit this group at http://groups.google.com/group/django-users. > >> >> > For more options, visit https://groups.google.com/groups/opt_out. > >> >> > > >> >> > > >> > > >> > -- > >> > 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...@googlegroups.com. > >> > To post to this group, send email to django...@googlegroups.com. > >> > Visit this group at http://groups.google.com/group/django-users. > >> > For more options, visit https://groups.google.com/groups/opt_out. > >> > > >> > > > > > -- > > 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...@googlegroups.com <javascript:>. > > To post to this group, send email to > > django...@googlegroups.com<javascript:>. > > > Visit this group at http://groups.google.com/group/django-users. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > -- 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. For more options, visit https://groups.google.com/groups/opt_out.
