I have a update preview page (working with Access 2000 database) that works but the only problem is if the text input has quotes in it the information is cut off where the quotes start:
Data entered in fieldOne: here is "word"
would be entered in database as: here is
Please advise how I can get this to work. I would like to keep using the "hidden" fields in the preview page so that is why I am not using cfinput.
Data entered in fieldOne: here is "word"
would be entered in database as: here is
Code:
The update page:
<cfquery datasource="dsname" name="q1">
select *
from tableOne
where fieldID = #URL.fieldID#
</cfquery>
<cfoutput query="q1">
<form action="Preview.cfm" method="post">
<input type="hidden" name="fieldID" value="#fieldID#">
<input type="text" name="fieldOne" value="fieldOne">
<input type="submit" name="Preview" value="Preview">
</form>
Preview.cfm page:
<cfparam name="form.fieldOne" default="">
Show Preview info:<br>
#FORM.fieldOne#<br>
<form action="actionPage.cfm" method="post">
<input type="hidden" name="fieldID" value="FORM.fieldID#">
<input type="hidden" name="fieldOne" value="FORM.fieldone#">
<input type="submit" value="Submit">
</form>
</cfoutput>
Please advise how I can get this to work. I would like to keep using the "hidden" fields in the preview page so that is why I am not using cfinput.