In the below code my list returned contains double quotes. When I run the page I get a javascript error that breaks the autosuggest. Telling me that I was missing a ; before statement becasue of the double quotes. I have searched quite a bit but not found anyone else explaining how to handle this.
<cfquery datasource="#request.datas
ource#" name="sizeList">
SELECT distinct(qiSize)
FROM quoteItem
</cfquery>
<cfoutput>
<cfform name="myForm" class="cms" method="post" action="#CGI.script_name#"
>
<table cellspacing="2" cellpadding="0" border="0" style="width:200px;">
<tr>
<td>
<label for="Size">Size</label>
<cfinput name="qiSize" value="#prepop.qiSize#" maxlength="50" type="text" autosuggest="#valueList(si
zeList.qiS
ize)#" autosuggestminlength="2">
</td>
</tr>
</table>
</cfform>
</cfoutput>
Start Free Trial