5 Replies Latest reply: Dec 9, 2011 10:52 AM by kategorgeous RSS

    Need some Help with CFUPDATE into MySQL

    kategorgeous Community Member

      Hi

       

      I am trying to update a MySQL database with a Coldfusion Form which has brought in the information from another form.  The Form action for the update form is as follows:

       

      <form action="update_sup.cfm?GID=#qsupname.SupplierCode#" method="post">

       

      This bit seems to work in so far as it generates a URL that includes the Supplier Code:

       

      www.website.com/update_sup.cfm?GID=193BA3BE-C09F-087E-DACCEE9702D6C5C1

       

      But the SQL query doesn't actually update:

       

      SQL Queries

        CFUPDATE (Datasource=kw5336, Time=0ms, Records=0) in /website/update_sup.cfm @ 22:27:00.000

       

      update Suppliers set SupplierName=?,SalesRepName=?,SalesRepPhone=?,Address1=?,Address2=?,Notes=? where SupplierCode=?

       

      The Form Fields in the Debug show the changes:

       

      Form Fields:

      FIELDNAMES=SUPCODE,SUPNAME,SUPADDR1,SUPADDR2,SUPCITY,SUPPCODE,SUPPTERMS,SUPREPNAME,SUPREPP HONE,SUPREPEMAIL,SUPNOTES

      SUPADDR1=Unit 55 Portland Drive

      SUPADDR2=Kiln Farm

      SUPCITY=Milton Keynes

      SUPCODE=193BA3BE-C09F-087E-DACCEE9702D6C5C1

      SUPNAME=SupplierF

      SUPNOTES=

      SUPPCODE=MK17 2RB

      SUPPTERMS=30

      SUPREPEMAIL=p.argent@supplierf.co.uk

      SUPREPNAME=Paul Argenta

      SUPREPPHONE=01555 123456

       

      What have I missed??