[SOLVED]  Update field after edit

This topic is locked

[SOLVED] Update field after edit	2/17/2010 12:39:35 PM
ASPRunnerPro General questions
T text author Hi I am trying to update the field "status" in my table (messages) with the word "Replied" after editing another field in the table. I thought the code below would do it but it doesn't seem to work. I'm not sure whether this is a before or after edit event in asprunner. inmessageID is the masterkey field in the table. MYSQL = "UPDATE messages SET status = 'Replied', WHERE inmessageID=" & dict("inmessageID") All help gratefully received. Thanks very much


T	text author 2/18/2010
	Hi I am trying to update the field "status" in my table (messages) with the word "Replied" after editing another field in the table. I thought the code below would do it but it doesn't seem to work. I'm not sure whether this is a before or after edit event in asprunner. inmessageID is the masterkey field in the table. MYSQL = "UPDATE messages SET status = 'Replied', WHERE inmessageID=" & dict("inmessageID") All help gratefully received. Thanks very much Solved it, the code that worked for me is: MYSQL = "UPDATE messages SET status = 'Replied' WHERE inmessageID=" & values("inmessageID")