<div>
Not sure about the jquery part, but in your SQL you can left pad with zeros...<br />
<br />
WHERE ZIPCODE = #right('00000' &amp;&nbsp;form.zipcode,5)#<br />

</div>


<div>
<div class="content wysiwyg-content">
I am using jquery autosuggest and it uses JSON to give the zipcodes as i type. &nbsp; The zipcodes are right in the database<br />
<br />
as 00620, 08690, etc,etc. &nbsp;But the JSON is dropping the leading zeros. &nbsp; How can I make it stay as a full string and not make it a number?
</div>
</div>


I am using jquery autosuggest and it uses JSON to give the zipcodes as i type.   The zipcodes are right in the database

as 00620, 08690, etc,etc.  But the JSON is dropping the leading zeros.   How can I make it stay as a full string and not make it a number?

Not sure about the jquery part, but in your SQL you can left pad with zeros...

WHERE ZIPCODE = #right(&#39;00000&#39; &amp; form.zipcode,5)#


SerializeJSON turning 08690 into 8690.. Help!

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.