Skip navigation
kategorgeous
Currently Being Moderated

Need some Help with CFUPDATE into MySQL

Dec 8, 2011 2:29 PM

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,SUPPTERM S,SUPREPNAME,SUPREPPHONE,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??

 
Replies
  • Currently Being Moderated
    Dec 8, 2011 3:10 PM   in reply to kategorgeous

    Look at the parameters passed to your database.  It's possible that you are only using the part of the GID up to the first hyphen.  If so, you can urlencode the variable or send it as a hidden form field instead.  I'd do the latter myself because I don't like having both url and form variables to deal with.

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 8, 2011 3:30 PM   in reply to Dan Bracuk

    SUPCODE, ..., SUPPCODE

     

    There are also two fields with very similar names. Is it possible the query is mixing them up?

     
    |
    Mark as:
  • Dave Watts
    747 posts
    Mar 11, 2003
    Currently Being Moderated
    Dec 8, 2011 3:41 PM   in reply to kategorgeous

    Are you sure it's not updating? I don't see any evidence of that from the example you posted. I don't think it shows a value for records updated in the debug output when you run an update.

     

    Dave Watts, CTO, Fig Leaf Software

     
    |
    Mark as:
  • Currently Being Moderated
    Dec 8, 2011 4:15 PM   in reply to Dave Watts

    I don't think it shows a value for records updated in the debug output when you run an update.

     

    I believe CF9 does display the number of records updated.  At least with a "regular" update.  But I agree that is not a very robust test.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points