Skip to main content
M
masoud_amen
Known Participant
April 23, 2008
Question

update

  • April 23, 2008
  • 2 replies
  • 392 views
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.
This topic has been closed for replies.

2 replies

M
masoud_amenAuthor
Known Participant
April 23, 2008
works.thank u so much.
S
SafariTECH
Inspiring
April 23, 2008
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
M
masoud_amenAuthor
Known Participant
April 23, 2008
ok.thanks.I'll try it and let u know about the result.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices