MX Kollection Forum :: Modifying form data before submit

Hi I am using an update form to modify a database record. However when the SUBMIT button is pressed I want to modify the contents of one of the form fields before it goes to the database.

Is there any way to simply intercept this data and then process it before it goes to the database?

I am using Developer Toolbox with ASP VB Script and MS SQL 2000 database.

(I did search and found an old post about a similar issue but that was in PHP and I could not really understand it, but I am okay with understanding VB Script)

Thankyou.

Neil --

Try Forms > Advanced > Add Transaction Fields. You should be able to modify any field in the database that is not affected by the form itself. Using this method is a better idea than using hidden fields because its in the database transaction code, not the visible form code.

-LR

Thanks

What I am trying to do is that when submit is clicked I want to intercept the value of one of the form fields (that a user has input) and modify it before it is sent to the database.

I am actually wanting to do a search and replace and change £ to £ because of a problem that Cute Editor has, see this post I made at the Cute website http://cutesoft.net/forums/thread/40359.aspx

I am okay with the ASP VB Script for doing the replacing - all I need to know is where to put the code! (ie how to intercept the form field value after submit is clicked and before the value is sent to the database)

Thanks in anticipation

Sorry, I'm not an ASP guy. But it seems logical that if you want to replace a character (£) to £ it may be wise not to send that character at all but to display it next to the field. If that does not work, you might have to go old school and replace (in your pages):

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />b

with

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />

Hope this helps -LR