2. ASPRunnerPro General questions
  3. Update
This topic is locked

Update

 		12/15/2005 13:06:46
ASPRunnerPro General questions
P
 pharaon_98 author

Hi
First time here, i d/l and am trying asp Runner Pro. Looks great and easy to use. Since i'm not a programmer, i find it very useful. Great software. Hope my boos will accept to buy it.
Anyway, i need help with something.
I need to modify a field when i save an edited a record.
Let me explain
When i modify the record, i need to modify a field automatically. I don't want the user to modify it. It's always the same info that needs to be saved. the data has to be changed from "new" to "waiting"...
Can this be done ? if so want do i have to change.
Is it possible to send an e-mail containing a link to the respond page (already created). the link has to look like this : http://webite.com/respond.asp and i need to add a value to reteive the info.
Thanks
Sergey Kornilov admin 12/16/2005

Hi,
you can modify pages created with ASPRunnerPro to add the functionality yoiu need.
To modify the field value when user edits the record please open generated ..._edit.asp file with a text editor, locate this line:

rs.Update



and insert this line just before:

rs("Field")="waiting"



where Field is your actual field name.
You can use sendmail function to send emails.

Insert this line to the same place:

sendmail("user@domain.com", "put your subject here", "put message text here")

or

sendmail(rs("email_field"), "put your subject here", "put message text here")

where email_field is the name of your actual field with email addresses.