Skip to main content
Inspiring
May 10, 2007
Question

CF SQL update using ODBC/DB2 no update

  • May 10, 2007
  • 1 reply
  • 313 views
The following will not update any of the ISSSxx fields but will update ISTXYR. I am at a loss. The field names are correct. The values can be retrieved from the DB2. I just can't update them.;

<cfquery name="updtQry" datasource="AS400" dbtype="ODBC">
UPDATE istatic1
SET
ISTXYR = '1953',
ISSS02 = 'A',
ISSS04 = 'A',
ISSS05 = 'A',
ISSS06 = 'A',
ISSS07 = 'A',
ISSS08 = 'A',
ISSS09 = 'B',
ISSS10 = 'B',
ISSS11 = 'B',
ISSS12 = 'B',
ISSS13 = 'B',
ISSS14 = 'B',
ISSS15 = 'B',
ISSS16 = 'C',
ISSS17 = 'c',
ISSS18 = 'c'
WHERE isrec## =99505
</cfquery>

There are no errors and no log entries.
This topic has been closed for replies.

1 reply

May 15, 2007
Try removing the dbtype attribute.