I've got a simple query to a MS Access 2003 database. I want to be able to
edit records using cfgrid. I am able to delete records without problem. I am
able to insert records. However, I have problems editing records, especially
when I insert a new record and don't complete all fields and attempt to go back
and edit the empty fields. Any help would be appreciated.

Here is the error:
Invalid data for CFSQLTYPE CF_SQL_DOUBLE.
The error occurred in C:\CFusionMX7\wwwroot\handle_grid.cfm: line 10
8 : <h3>Updating MBS Offerings</h3>
9 :
10 : <cfgridupdate grid="mbsdata"
11 : datasource="myPiperData"
12 : tablename="MBS">

--------------------

Code for "offerings.cfm" page:

<cfquery name="MBSOffers" datasource="myPiperData" username="krmanz"
password="2448487">
SELECT *
FROM MBS
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Offerings</title>
<link href="main.css" rel="stylesheet" type="text/css">
</head>

<body>
<cfform name="GridForm" width="1065" height="500" action="handle_grid.cfm">
<cfinput name="submitit" type="Submit" value="Submit">
<cfgrid name="mbsdata"
height=300
width=1000
vspace=10
selectmode="edit"
query="MBSOffers"
insert="Yes"
delete="Yes">
<cfgridcolumn name = "ID" header = "ID" width="30" select="no">
<cfgridcolumn name = "CUSIP" header = "CUSIP" width="60">
<cfgridcolumn name = "PRODUCT" header = "PRODUCT" width="60">
<cfgridcolumn name = "TYPE" header = "TYPE" width="50">
<cfgridcolumn name = "ORIGFACE" header = "ORIGFACE" width="75">
<cfgridcolumn name = "SECURITY" header = "SECURITY" width="100">
<cfgridcolumn name = "COUP" header = "COUP" width="40">
<cfgridcolumn name = "COLLAT" header = "COLLAT" width="80">
<cfgridcolumn name = "MATURITY" header = "MATURITY" width="80">
<cfgridcolumn name = "WAM" header = "WAM" width="40">
<cfgridcolumn name = "LIFE" header = "LIFE" width="40">
<cfgridcolumn name = "PACBAND" header = "PACBAND" width="50">
<cfgridcolumn name = "WINDOW" header = "WINDOW" width="60">
<cfgridcolumn name = "MTR" header = "MTR" width="60">
<cfgridcolumn name = "CAPS" header = "CAPS" width="60">
<cfgridcolumn name = "MARGIN" header = "MARGIN" width="60">
<cfgridcolumn name = "OFFER" header = "OFFER" width="60">
<cfgridcolumn name = "SPEED" header = "SPEED" width="60">
<cfgridcolumn name = "YIELD" header = "YIELD" width="50">
<cfgridcolumn name = "SETTLE" header = "SETTLE" width="50">
<cfgridcolumn name = "PRICE" header = "PRICE" width="50">
<cfgridcolumn name = "COMMENT" header = "COMMENT" width="120">
<cfgridcolumn name = "SC" header = "SC" width="30">
</cfgrid>
<br>

</cfform>

</body>
</html>

----------------

Code for "handle_grid.cfm":
<html>
<head>
<title>Update grid values</title>
<link href="main.css" rel="stylesheet" type="text/css">
</head>
<body>

<h3>Updating MBS Offerings</h3>

<cfgridupdate grid="mbsdata"
datasource="myPiperData"
tablename="MBS">

Click <a href="offerings.cfm">here</a> to display updated grid.

</body>
</html>
-----------------

I've tried using cfquery but I get this error:

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be
displayed.

--------

Code for "cfqueryupdate1.cfm":
<html>
<head>
<title>Catch submitted grid values</title>
<link href="main.css" rel="stylesheet" type="text/css">
</head>
<body>

<h3>Grid values for Form.mbsdata row updates</h3>

<cfif isdefined("Form.mbsdata.rowstatus.action")>

<cfloop index = "Counter" from = "1" to
=#arraylen(Form.mbsdata.rowstatus.action)#>
<cfoutput>
The row action for #Counter# is:
#Form.mbsdata.rowstatus.action[Counter]#
<br>
</cfoutput>

<cfif Form.mbsdata.rowstatus.action[counter] is "D">

<cfquery name="DeleteMBSOffers"
datasource="myPiperData">
DELETE FROM MBS
WHERE
ID=#Form.mbsdata.original.ID[Counter]#
</cfquery>

<cfelseif Form.mbsdata.rowstatus.action[counter] is "U">

<cfquery name="UpdateMBSOffers"
datasource="MBSOffers">
UPDATE MBS
SET
ID=#Form.mbsdata.ID[Counter]#,
'CUSIP=#Form.mbsdata.CUSIP[Counter]#',
'PRODUCT=#Form.mbsdata.PRODUCT[Counter]#',
'TYPE=#Form.mbsdata.TYPE[Counter]#',
ORIGFACE=#Form.mbsdata.ORIGFACE[Counter]#,
'SECURITY=#Form.mbsdata.SECURITY[Counter]#',
COUP=#Form.mbsdata.COUP[Counter]#,
'COLLAT=#Form.mbsdata.COLLAT[Counter]#',
'MATURITY=#Form.mbsdata.MATURITY[Counter]#',
WAM=#Form.mbsdata.WAM[Counter]#,
LIFE=#Form.mbsdata.LIFE[Counter]#,
'PACBAND=#Form.mbsdata.PACBAND[Counter]#',
'WINDOW=#Form.mbsdata.WINDOW[Counter]#',
'MTR=#Form.mbsdata.MTR[Counter]#',
'CAPS=#Form.mbsdata.CAPS[Counter]#',
'MARGIN=#Form.mbsdata.MARGIN[Counter]#',
'OFFER=#Form.mbsdata.OFFER[Counter]#',
'SPEED=#Form.mbsdata.SPEED[Counter]#',
YIELD=#Form.mbsdata.YIELD[Counter]#,
'SETTLE=#Form.mbsdata.SETTLE[Counter]#',
'PRICE=#Form.mbsdata.PRICE[Counter]#',
'COMMENT=#Form.mbsdata.COMMENT[Counter]#',
SC=#Form.mbsdata.SC[Counter]#
WHERE
ID=#Form.mbsdata.original.ID[Counter]#
</cfquery>

<cfelseif Form.mbsdata.rowstatus.action[counter] is "I">

<cfquery name="InsertNewOffer"
datasource="myPiperData">
INSERT into MBS
(, ID)
VALUES #Form.mbsdata.CUSIP[Counter]#,
#Form.mbsdata.PRODUCT[Counter]#,
#Form.mbsdata.TYPE[Counter]#,
#Form.mbsdata.ORIGFACE[Counter]#,
#Form.mbsdata.SECURITY[Counter]#,
#Form.mbsdata.COUP[Counter]#,
#Form.mbsdata.COLLAT[Counter]#,
#Form.mbsdata.MATURITY[Counter]#,
#Form.mbsdata.WAM[Counter]#,
#Form.mbsdata.LIFE[Counter]#,
#Form.mbsdata.PACBAND[Counter]#,
#Form.mbsdata.WINDOW[Counter]#,
#Form.mbsdata.MTR[Counter]#,
#Form.mbsdata.CAPS[Counter]#,
#Form.mbsdata.MARGIN[Counter]#,
#Form.mbsdata.OFFER[Counter]#,
#Form.mbsdata.SPEED[Counter]#,
#Form.mbsdata.YIELD[Counter]#,
#Form.mbsdata.SETTLE[Counter]#,
#Form.mbsdata.PRICE[Counter]#,
#Form.mbsdata.COMMENT[Counter]#,
#Form.mbsdata.SC[Counter]#
</cfquery>

</cfif>
</cfloop>
</cfif>
Goto <a href="offerings.cfm">offers</a></body>
</html>

Works fine to delete, doesn't work for insert or edit.