Posted by Jeffrey Roberson
We just finished the updated layout programming for Sam Moore. They wanted the site to look more like the existing www.hookerfurniture.com parent site while adding updated meta data, social networking, fabrics, and product information. The site was originally in ASP/HTML and didn't match their new marketing. It's been completely redone with Coldfusion, mySQL, jQuery, and YUI grids.
Posted by Jeffrey Roberson
This post is more for my notes so I remember it, but once again Ben Nadel's blog saved the day.
My problem was similar, but I was getting "Data Truncated for Column" errors using MYSQL import. To stop this error, basically just let mysql truncate teh fields without throwing the error. Follow Ben's instructions for whichever version of the driver you are using. Except you want to add jdbcCompliantTruncation=false to the driver. If you have multiple parameters then you separate them with an &.
Posted by Jeffrey Roberson
My friend's over at Chatmoss Web Systems launched the updated version of Bassett Mirror Company's website this week.
I think they did a wonderfull job, but you may be asking why am I posting about it? I helped out with the images :) The site is being powered by our image library and web services from FurnishWEB written in Coldfusion and hosted on Amazon's S3.
Posted by Jeffrey Roberson
This is a continuation of my last post. In my effort to not have a million domain names and hosts file edits; I setup my TOMCAT server on ec2 the same way as the jetty server on my laptop :). This is to get SES urls to work on TOMCAT in a subfolder.
To get http://my.ec2-server.com/site1/index.cfm/fuseaction/my.page/test/1 to function properly we do something similar to Jetty. This time we edit the /opt/railo/tomcat/conf/web.xml file. Search for /index.cfm/*
<servlet-mapping>
<servlet-name>CFMLServlet</servlet-name>
<url-pattern>/index.cfm/*</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>CFMLServlet</servlet-name>
<url-pattern>/site1/index.cfm/*</url-pattern>
</servlet-mapping>
Run
/opt/railo/railo_ctl restart
And you are all set.
Posted by Jeffrey Roberson
I've been working my way through learning the ins and outs of Railo over the last few months. So far I'm impressed, but still trying to figure out all the quirks.
Our sites use Fusebox and SES url's and for some reason they would work on my EC2 instance and not on my laptop. If I searched for a solution most of the posts were old and pointed to .cfm/* and .cfc/* needing to be added to the /railo/etc/defaultweb.xml. It seems in the latest download these are already added. So that didn't help me. I finally figured it out though. When I develop on my laptop I have all my webs in subfolders under the main web root : http://localhost:8888/cfbuilder/site1/index.cfm/fuseaction/my.page/test/1 for example. The mappings only seem to work if the site is in the root. So to get this to work you have to add :
<servlet-mapping>
<servlet-name>CFMLServlet</servlet-name>
<url-pattern>*.cfm</url-pattern>
<url-pattern>*.cfml</url-pattern>
<url-pattern>*.cfc</url-pattern>
<url-pattern>*.cfm/*</url-pattern>
<url-pattern>*.cfml/*</url-pattern>
<url-pattern>*.cfc/*</url-pattern>
<url-pattern>/*.cfm/*</url-pattern>
<url-pattern>/cfbuilder/site1/index.cfm/*</url-pattern>
</servlet-mapping>
Kinda of a pain to add each site manually to the file, but it works. So I can't complain too much.