Integer fields for zip codes can be problematic in the case of a zip code like 08817 (tends to strip off the leading zero).
On Thu, Oct 22, 2009 at 11:35 AM, Timothy Laureska < tlaure...@dhmh.state.md.us> wrote: > > Is there any reason you're not using an integer field type of some sort? > > > >>> Douglas Brown <mistobr...@gmail.com> 10/22/2009 2:24 PM >>> > > >I'd need to see the datatype of the zipcode column as well as the content > >of the 'valid zipcode' variable before I could answer the question, but my > >guess would be that there's a discrepancy in datatype: '#validZipCode#' > >when it should be #validZipCode# or something like that. > > > The datatype is nvarchar(5) the zipcode is just a simple US zipcode '81416' > for example. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327517 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
