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)
> VALUES ('#TRIM(FORM.CUM_GPA)#')
> </cfquery>
>
>
> CUM_GPA is not being inserted for me, however other users have had
> different data that is lost. This variable is NOT being stored as a
> session variable.
>
> Thx John
>
>
>
>
> >can you post the form code, insert code, and variable values that
> did
> >not insert properly?
> >
> >On 4/18/07, John P <[EMAIL PROTECTED]> wrote:
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275873
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
