I am trying to update a property field using stored procedure. My idea is to take in two parameters that are also property fields and update one of the property fields with a new value.
My overall scope is that I need to update a quantity after a paypal transaction is completed. I've been using PDT provided by paypal to retrieve a final detail of the transaction of the customer. Based on the sku and quantity purchased, I want to update the quantity.
I was considering the stored procedure for performance reasons. But I don't want to mess up the database if that may be the case, so I will utilize the API.
Changing a property field with a stored procedure.
Hi All,
I am trying to update a property field using stored procedure. My idea is to take in two parameters that are also property fields and update one of the property fields with a new value.
My overall scope is that I need to update a quantity after a paypal transaction is completed. I've been using PDT provided by paypal to retrieve a final detail of the transaction of the customer. Based on the sku and quantity purchased, I want to update the quantity.
Any ideas or thoughts would be great.
Thanks
Dan
Hi Dan,
I would never change a property by modifying the database. You can change properties by using the Umbraco API. An example can be found at http://our.umbraco.org/wiki/reference/api-cheatsheet/modifying-document-properties
Cheers,
Richard
Thanks Richard, I think that I will try to pass the Node Id as well to make it simpler for me to update the document property.
why a stored proc and not the API? The API is meant for these kind of opertations a stored proc might in worst case scenario corrupt your database
I was considering the stored procedure for performance reasons. But I don't want to mess up the database if that may be the case, so I will utilize the API.
is working on a reply...