3 Replies Latest reply on Apr 23, 2008 2:44 PM by masoud_amen

    update

    masoud_amen
      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.