can you do a <cfdump var="#form#"> on top of action.cfm and make sure
a value (and the value you expect) is being passed?
also... you're just inserting a single record? not trying to update a
particular existing record?
On 4/18/07, John P <[EMAIL PROTECTED]> wrote:
> 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 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:275795
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
