Skip navigation
Currently Being Moderated

post method on the form

Feb 15, 2013 4:08 PM

I set my form methos to post. I would like to know does ColdFusion is smart enough to know to insert or update physical database.

If record exists then ColdFusion server knows to update, if not then ColdFusion insert a record.

If not, should I have one form for Edit and one form for insert to same table?

If not, any solution for this?

Do I need check myself does record exist, if yes run SQL to update, or if not then inser record?

 

Your help and information is great appreciated,

 

Regards,

 

Iccsi,

 
Replies
  • Currently Being Moderated
    Feb 16, 2013 5:40 AM   in reply to iccsi

    Iwould strongly suggest you check out cfwheels. Read the documentation, it's built for doing such crud applications and has an amazing set of features and will save you a lot of time.

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 16, 2013 6:50 AM   in reply to iccsi

    In principle you could use the same form for insert and update, although I usually use two forms.

     

    You will need to find out whether a record exists and use that value to when applying the SQL, update or insert.

     

    My knowledge of CF goes back more than ten years, and I would be of no use to you. I think it best if you go to a forum that covers CF

     
    |
    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