update
in [Advanced Techniques]
|
From: masoud_amen on 23 Apr 2008 15:48 Hi.I have a form that updates all the fields.I have 2 fields: Current Cost:<input type="text" name="productprice" value="#NumberFormat(product.product_price, "_.__")#" size="8"> Current Selling Price:<!---#price.product_price# ---><input type="text" name="productBasePrice" value="#NumberFormat(product.product_current_price, "_.__")#" size="8"> which they will be update correctly when we submit the form and the this procedure runs: <CFSTOREDPROC procedure="sp_Update_Pricing2" dataSource="#session.eManager.datasource#"></CFSTOREDPROC> now my problem is I want this query runs only if we change the value of those 2 fields.but this query runs whenever we push the submit button. thanks for yr help.
From: SafariTECH on 23 Apr 2008 16:46 unless you want to check the values against the DB values first, and then run the procedure, my suggestion may be to have 4 fields: The 2 fields you mention and then 2 hidden fields that contain the data from the DB - when you submit the form, compare the hidden fields with the visible fields and see if anything changed. If they changed, then run the procedure. JMO
From: masoud_amen on 23 Apr 2008 17:07 ok.thanks.I'll try it and let u know about the result.
From: masoud_amen on 23 Apr 2008 17:44 works.thank u so much.
|
Pages: 1 Prev: Chinese Mics - OEM Chinese Mics Manufacturer Next: autosuggest problems with cf8 |