I've got a very bizarre problem. I'm trying to do an update to my table, but it appears that I can only update 13 fields. Below is my query:
<CFQUERY NAME="InsertRequest" DATASOURCE="esidb1">
UPDATE tblmasterclients
SET acctstatus = '#Form.acctstatus#',
siteid = '#Form.siteid#',
authcode = '#Form.authcode#',
svctype = '#Form.svctype#',
pobox = '#Form.pobox#',
poboxcombo = '#Form.poboxcombo#',
DID = '#Form.DID#',
SecDID = '#Form.secdid#',
FaxDID = '#Form.faxdid#',
URL = '#Form.url#',
prepareddate = '#Form.prepareddate#',
eighthundreddid = '#Form.eighthundreddid#',
faxext = '#Form.faxext#',
terminationdesc = '#Form.terminationdesc#'
terminationreason = '#Form.terminationreason#',
inactivedate = '#form.inactivedate#',
commencementanni = '#form.commencementanni#'
WHERE clientID = #Form.clientID#
</CFQUERY>
Trying to do an update with any data beyond the faxext line above, generates a "datatype mismatch" error. HOWEVER, If I delete any 4 lines and move the bottom four lines to those lines, all works fine. This does not seem to be related to a datatype mismatch error, but more of a limitation of the number of fields I can update? Also, this is happening with multiple tables in my database. Is there a setting in Cold Fusion Administrator I'm missing? Is there an implied order of updates that could be causing this?
Help!
Thanks
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
