On Friday 05 May 2006 19:41, evenrik wrote: > Using pre magic removal I got this error: > > Exception Type: ProgrammingError > Exception Value: ERROR: unterminated quoted string at or near > "'F28T8/841 T8 4'' " at character 419 select count(a.id) from > uv2_applications as a inner join uv2_rebatableobjects as r on > a.ro_id=r.id inner join uv2_ro_lowwatt_cms as lwt on r.id=lwt.ro_id > inner join uv2_customers as c on a.c_id=c.id where a.objstate != 600 > and a.id != 268 and c.address_hash = > '46d2b9507ea1f13455675013b6cb0504' and c.address_hash != '' and > (lwt.model) = 'F28T8/841 T8 4'' Exception Location: > /usr/lib/python2.3/site-packages/django/core/db/base.py in execute, > line 9 > > The "model" field has the data F28T8/841 T8 4' that is creating the > error. > Has anyone a fix for this? For now I just changed the quote to ft in > the DB.
What command are you executing that generates this? It looks like you are generating your SQL manually (rather than letting Django create it for you), in which case you have to be sure to escape your data properly. Luke -- "It is a truth universally acknowledged, that a single man in possession of a good fortune, must be in want of a wife." (Jane Austen) Luke Plant || L.Plant.98 (at) cantab.net || http://lukeplant.me.uk/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
