Thanks all. Carl, does cfparam as you described discretely tell CF and SQL that the insert is a numerical data type? In what instances is that advised? Why is it necessary?
I've isolated the issue to a server memory problem, I believe, and solved it (I hope) by restarting the server. Thank you all for your help. >John, > >You might want to try using CFQUERYPARAM in your insert query. Something like: > >INSERT INTO STUDENT_ACADEMICS (CUM_GPA) >VALUES (<cfqueryparam value="#TRIM(FORM.CUM_GPA)#" CFSQLTYPE="CF_SQL_NUMERIC">) > >Set the CFSQLTYPE to the appropriate type to match the data type of the SQL >field. > >HTH, >Carl > > >> Form code: >> <cfform name="ThisForm" method="post" action="action.cfm"> > >> <cfinput type="Text" name="Cum_GPA" message="GPA is required" >> required="Yes" size="8">... >> >> Insert: >> <cfquery name="InsertGPA" datasource="server"> > >> INSERT INTO STUDENT_ACADEMICS (CUM_GPA) > >>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275969 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
