I am using MYSql with latin-1 encoding.

I get some weird intermittent errors when using custom sql. I have a
large programatically generated sql, and when I try to run this as
cursor.execute(sql), it works sometime but fails other times. The only
big difference I can see between the sqls is that whenever it fails it
has a unicode char. Traceback follows. Any pointers where I should be
looking to solve this problem.

G:\tapicks\news\cron.py in find_recommeneded_for_username(username)
    114     import pdb
    115     pdb.set_trace()
--> 116     cursor.execute(sql)
    117     return cursor.fetchall()
    118

C:\Python24\lib\site-packages\django\db\backends\util.py in
execute(self, sql, params)
     19         finally:
     20             stop = time()
---> 21             sql = self.db.ops.last_executed_query(self.cursor,
sql, params)
     22             self.db.queries.append({
     23                 'sql': sql,

C:\Python24\lib\site-packages\django\db\backends\__init__.py in
last_executed_query(self, cursor, sql, params)
    148             u_params = dict([(to_unicode(k), to_unicode(v))
for k, v in params.items()])
    149
--> 150         return smart_unicode(sql) % u_params
    151
    152     def last_insert_id(self, cursor, table_name, pk_name):

TypeError: not enough arguments for format string

--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to