Pong wrote:
> Hi,
>
> what is wrong with this query?
>
> user_id_tuple = (2, 3, 25, 15) # for example
> cursor = connection.cursor()
> cursor.execute(""""SELECT
> week, year, SUM(data), SUM(data1), SUM(data2),
> SUM(data3),
> SUM(data4) FROM user_table
> WHERE user_id IN %s GROUP BY week, year
> ORDER BY year, week""" , [user_id_tuple])
>
> Django gives me OperationalError when I try to run it. I tried the
> same query with mysql on different server(same django version) and it
> worked great.Since you're talking about the sqlite backend, did you try this on the sqlite command-line? Mike -- Michael P. Soulier <[EMAIL PROTECTED]> "Any intelligent fool can make things bigger and more complex... It takes a touch of genius - and a lot of courage to move in the opposite direction." --Albert Einstein
signature.asc
Description: OpenPGP digital signature
