thecfguy

A Unique Developer

<br> tag create seperate row in exported excel
Tags: ColdFusion
Comments(0)
404 Page not found displayed when try to download .xlsx extention

Today I face really strange issue, when I tried to download filewith extention .xlsx and browser redirect me on 404 Page not foundpage. My belief is whenever IIS (webserver) found file is not scriptfile then it will let browser to download the file but in this case ittook me to "Page Not Found" page.

I have done googling for this and Solution is really simple. We require to add Mime type 'application/octet-stream' in IIS.

Tags: IIS
Comments(2)
Finding Zip code list within specified miles

I was just working around to get list zip code within 25 miles of radius for given address. I have database table for Zip Codes with below columns.

  • "zip" - Store zip code
  • "zip_latitude" - Store latitude
  • "zip_longitude" - Store longitude

I have created MS SQL function which returns sql table object with list of all zip codes within specified radius in which you might interested.

 

Tags: SQL
Comments(1)
Coldfusion function to avoid sql injection
Tags: ColdFusion, SQL
Comments(1)
Wrapping text in CFGrid
Tags: ColdFusion
Comments(4)