0 Replies Latest reply on Aug 6, 2007 2:57 PM by GeorgeWS

    Updating a DB Table using ColdFusion(CFC)

    GeorgeWS Level 1
      I need help BAD... please
      I have this app. most stuff works perfect. I just can seem to append the form fields to each row that gets checked in the Datagrid. I get errors with the dateField also. Can anyone help?

      This is my source:
      http://www.youngsmarket.com/youngsmarket/programs/national/nataccpro/bin/srcview/index.htm l

      This is the App in its current state. The form fileds update if a date is not selected. But I cant send the DataGrid or the date form fields:
      http://www.youngsmarket.com/youngsmarket/programs/national/nataccpro/bin/NatAccPro.cfm?Sup plierID=30

      My CFC that I want to UPDATE the table (I know need a loop or something) is like this:

      <cffunction name="addData" access="remote" output="false" hint="I insert data" returntype="void">
      <cfargument name="user" type="struct" required="true" />

      <CFQUERY DATASOURCE="NationalAccounts">
      INSERT INTO Programs
      (SupplierID, Supplier, DBA, ItemID, Item, StartDate, EndDate, ProgramType, Status, Priority, Descrip, FollowUp, TrackComp, PresLocal, TrackSales)
      values
      ('#Session.SupID#', '#Session.Sup#', '#user.DBA#', '#user.ItemID#', '#user.Item#', '#user.StartDate#', '#user.EndDate#', '#user.ProgramType#', '#user.Status#', '#user.Priority#', '#user.Descrip#', '#user.FollowUp#', '#user.TrackComp#', '#user.PresLocal#', '#user.TrackSales#')
      </CFQUERY>
      </cffunction>


      Thanks
      George