var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL statement - Invalid cursor state
i am connecting to a MS Access DB, i am able to execute all the other select statments, except this one (presumably due to the SUM(Amount) as Total.
SELECT invoice_type, SUM(Amount) as Total FROM invoice WHERE invoice_date >= #1 April 2004# AND invoice_date < #1 April 2005# AND Student_ID = 31 GROUP BY invoice_type
I get an "Invalid Cursor State".
The query works if i create a new one in Access itself, but i need the variables to be different each time.
Did you try to execute the query statement without SUM() function?
SELECT invoice_type FROM invoice WHERE invoice_date >= #1 April 2004# AND invoice_date < #1 April 2005# AND Student_ID = 31 GROUP BY invoice_type