I have some forms for userinput of text.
If I handcode the insert or update function I can do a normal replace function like replace(text,""",""".
But using Dreamweavers "Update (or insert) Form behavior" it generates a lot of code, and I cannot understand all of it.
Is there a way to make the replacement of the form field before building the string like:
MM_fieldsStr = NameFld|value|AddressFld|value...
MM_columnsStr = Name|none,none,NULL|PIC_NAME|',none,'...

Sorry to be that fast requesting help... I think I have found the solution myself: This piece of code must be the place to do the work:

MM_formVal = "'" & Replace(MM_formVal,"'","''" & "'"

If I change this to (or insert it as a new line beneath):

MM_formVal = "'" & Replace(MM_formVal,""","&qout;" & "'"

This must do the job...

Edited by - houmann on 22 Dec 2005 23:08:19