This code causes problems:
<CFQUERY NAME="UpdateDetailRecord" DATASOURCE="#DataDB#">
UPDATE Product
SET
PartNo = '#Trim(FORM.PartNo)#',
UPCNo = '#Trim(FORM.UPCNo)#'
WHERE ProductID = #FORM.ProductID#
</CFQUERY>
Sometimes it produces no errors, but about half the time I get errors back
like this:
Error Occurred While Processing Request
Error Diagnostic Informationunknown exception condition
CFMLInterpreterImp::writeEmergencyMessage Date/Time: 05/06/01 16:19:10
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98; BCD2000)
Remote Address: 64.135.30.238
The datasource name is set in application.cfm and is 942_autoparts.
Can you see anything wrong with this simple update query? All the form
variables are present, I'm thinking maybe there's a reserved-word problem
but I don't know what it could be. I'd sure appreciate any help on
this. I get the same kind of errors on 3 different machines with this
code, it's not a corrupted executable ColdFusion code problem.
Regards,
Karl Simanonok
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
