Database query errors

[noobie2005]

Good morning,

First off, I would like to give thanks in advance to those who help. I have
the following query statement, but I still get an error, and I can't figure out
whats wrong with it. Here's the query

<cfquery datasource="financialfreedom" name="qffp">
UPDATE Debits
INSERT INTO Debits
(Housing,SavingsCredit,Auto,Misc,Food,InsurMedical ,Personal,MonthlyIncome,Total_
Expense,Recommended_Total,Net_Income)
VALUES
(#Housing#,#SavingsCredit#,#Auto#,#Misc#,#Food#,#I nsurMedical#,#Personal#,#Mont
hlyIncome#,#Total_Expense#,#Recommended_Total#,#Ne t_Income#)
</cfquery>

And if I take out the UPDATE statement I get the following:
ODBC Error Code = S1000 (General error)

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.

The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (51:1) to (51:51).

I can't figure out whats going on. Any help is apreciated. Thanks!

[noobie2005]

DOH! Yeah..thanks for pointing that out. I got it working shortly after I posted this. I have a different question though.

The <CFGRAPH> tag, is that an 4.5 tag or an MX tag?

[Dan Bracuk]

cfgraph is available in version 4.5. However, it worked differently then than
it does now and the code is not interchangeable. If you are using version 4.5,
you'll need the version 4.5 version of the cfml reference manual.