// API callback
related_results_labels_thumbs({"version":"1.0","encoding":"UTF-8","feed":{"xmlns":"http://www.w3.org/2005/Atom","xmlns$openSearch":"http://a9.com/-/spec/opensearchrss/1.0/","xmlns$blogger":"http://schemas.google.com/blogger/2008","xmlns$georss":"http://www.georss.org/georss","xmlns$gd":"http://schemas.google.com/g/2005","xmlns$thr":"http://purl.org/syndication/thread/1.0","id":{"$t":"tag:blogger.com,1999:blog-8359992897615744154"},"updated":{"$t":"2021-09-16T07:33:07.445+10:00"},"category":[{"term":"CFML"},{"term":"Linux"},{"term":"SQL"},{"term":".NET"},{"term":"Javascript"}],"title":{"type":"text","$t":"It is what it is, sometimes it helps."},"subtitle":{"type":"html","$t":""},"link":[{"rel":"http://schemas.google.com/g/2005#feed","type":"application/atom+xml","href":"http:\/\/blog.kukiel.net\/feeds\/posts\/default"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/-\/CFML?alt=json-in-script\u0026max-results=6"},{"rel":"alternate","type":"text/html","href":"http:\/\/blog.kukiel.net\/search\/label\/CFML"},{"rel":"hub","href":"http://pubsubhubbub.appspot.com/"},{"rel":"next","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/-\/CFML\/-\/CFML?alt=json-in-script\u0026start-index=7\u0026max-results=6"}],"author":[{"name":{"$t":"Paul Kukiel"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/09506704719956887151"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"generator":{"version":"7.00","uri":"http://www.blogger.com","$t":"Blogger"},"openSearch$totalResults":{"$t":"10"},"openSearch$startIndex":{"$t":"1"},"openSearch$itemsPerPage":{"$t":"6"},"entry":[{"id":{"$t":"tag:blogger.com,1999:blog-8359992897615744154.post-660062359510524119"},"published":{"$t":"2011-08-15T09:14:00.001+10:00"},"updated":{"$t":"2016-03-03T11:22:21.546+11:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"CFML"}],"title":{"type":"text","$t":"Write dump in cfmail with cfscript in ColdFusion"},"content":{"type":"html","$t":"I find it handy to dump out a scope and email it to myself.  I use this occasionally in Application.cfc in onError() or onMissingTemplate() to dump cgi and the exception variables.\u003Cbr \/\u003E\u003Cbr \/\u003EThis weekend I was working on a small ColdFusion project and am using cf9.  All my cfc's are in script and I wanted to dump full scopes and email them back to myself.  Its not as simple as in tags but its a workable solution using savecontent.\u003Cbr \/\u003E\u003Cbr \/\u003EI really expected this to just work:\u003Cbr \/\u003E\u003Cbr \/\u003Email.addPart( type=\"html\", charset=\"utf-8\", body=writedump(application) );\u003Cbr \/\u003E\u003Cbr \/\u003EBut it wont so here is the solution:\u003Cbr \/\u003E\u003Cbr \/\u003EHere is the solution:\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cscript src=\"http:\/\/pastebin.com\/embed_js.php?i=NDLUq6tw\"\u003E\u003C\/script\u003E\u003Cbr \/\u003E\u003Cbr \/\u003EThe other exception to my project was one cfc had to have a udf for cfexecute which also is not yet in cfscript.\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cbr \/\u003EUpdate.\u003Cbr \/\u003E\u003Cbr \/\u003ETo answer Steves question here is the code example.\u003Cbr \/\u003E\u003Cbr \/\u003EYou can just attach the report as a file attachment and specify the content.\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cscript src=\"http:\/\/pastebin.com\/embed_js.php?i=X2Y5zJbQ\"\u003E\u003C\/script\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/blog.kukiel.net\/feeds\/660062359510524119\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/blog.kukiel.net\/2011\/08\/write-dump-in-cfmail-with-cfscript-in.html#comment-form","title":"5 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/660062359510524119"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/660062359510524119"},{"rel":"alternate","type":"text/html","href":"http:\/\/blog.kukiel.net\/2011\/08\/write-dump-in-cfmail-with-cfscript-in.html","title":"Write dump in cfmail with cfscript in ColdFusion"}],"author":[{"name":{"$t":"Paul Kukiel"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/09506704719956887151"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"thr$total":{"$t":"5"}},{"id":{"$t":"tag:blogger.com,1999:blog-8359992897615744154.post-659846702643316416"},"published":{"$t":"2010-01-31T12:33:00.000+11:00"},"updated":{"$t":"2016-03-03T13:02:12.052+11:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"CFML"}],"title":{"type":"text","$t":"Easiest way to upgrade your ColdFusion JDK"},"content":{"type":"html","$t":"I just got a new laptop and have been setting up my local dev environment.  After installing IIS and ColdFusion ( 8 and 9 ) I wanted to bump the JDK past the class loader issues with pre 1.6.0_10.  I figured I'd go with the most recent ( 1.6.0_18 )\u003Cbr \/\u003E\u003Cbr \/\u003EThis is a simple process and I'll outline it here.  This is the same on Win XP, 2003, Vista, Windows 2008 and Windows 7.\u003Cbr \/\u003E\u003Cbr \/\u003EDownload the JDK:  http:\/\/java.sun.com\/javase\/downloads\/index.jsp\u003Cbr \/\u003E\u003Cbr \/\u003EChoose the appropriate edition ( I'm running 64bit Windows and CF8 ) so 64 bit edition for me.  Make sure you get the JDK not the JRE.\u003Cbr \/\u003E\u003Cbr \/\u003EInstall the JDK and take note of the install directory.  I left it all as default and the install folder is: C:\\Program Files\\Java\\jdk1.6.0_18\u003Cbr \/\u003E\u003Cbr \/\u003EBrowse to you CFADMIN and select \u003Cb\u003EJava\u003C\/b\u003E \u003Cb\u003Eand Java Settings:\u003Cbr \/\u003E\u003C\/b\u003E\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"http:\/\/1.bp.blogspot.com\/_hxgUC3p3PNI\/S2Tcqbt9ruI\/AAAAAAAAC9I\/mpcXtCiL1UI\/s1600-h\/Untitled.png\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" height=\"444\" src=\"https:\/\/1.bp.blogspot.com\/_hxgUC3p3PNI\/S2Tcqbt9ruI\/AAAAAAAAC9I\/mpcXtCiL1UI\/s640\/Untitled.png\" width=\"640\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cbr \/\u003EReplace the \u003Cb\u003EJava Virtual Machine path\u003C\/b\u003E with C:\\Program Files\\Java\\jdk1.6.0_18\\jre\u003Cbr \/\u003E\u003Cbr \/\u003ESave this and restart your CouldFusion services.\u003Cbr \/\u003E\u003Cbr \/\u003ELog back into the CFADMIN click \u003Cb\u003ESettings and Summary\u003C\/b\u003E and confirm the java version is now 1.6.0_18.\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"http:\/\/1.bp.blogspot.com\/_hxgUC3p3PNI\/S2TdvfR5_SI\/AAAAAAAAC9Q\/7LLJoXcYXOQ\/s1600-h\/Capture.PNG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" height=\"274\" src=\"https:\/\/1.bp.blogspot.com\/_hxgUC3p3PNI\/S2TdvfR5_SI\/AAAAAAAAC9Q\/7LLJoXcYXOQ\/s640\/Capture.PNG\" width=\"640\" \/\u003E\u003C\/a\u003E\u0026nbsp;\u003C\/div\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: left;\"\u003EAnd that's it.\u003C\/div\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/blog.kukiel.net\/feeds\/659846702643316416\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/blog.kukiel.net\/2010\/01\/easiest-way-to-upgrade-your-coldfusion.html#comment-form","title":"7 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/659846702643316416"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/659846702643316416"},{"rel":"alternate","type":"text/html","href":"http:\/\/blog.kukiel.net\/2010\/01\/easiest-way-to-upgrade-your-coldfusion.html","title":"Easiest way to upgrade your ColdFusion JDK"}],"author":[{"name":{"$t":"Paul Kukiel"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/09506704719956887151"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"https:\/\/1.bp.blogspot.com\/_hxgUC3p3PNI\/S2Tcqbt9ruI\/AAAAAAAAC9I\/mpcXtCiL1UI\/s72-c\/Untitled.png","height":"72","width":"72"},"thr$total":{"$t":"7"}},{"id":{"$t":"tag:blogger.com,1999:blog-8359992897615744154.post-1879252002572218250"},"published":{"$t":"2009-12-02T02:14:00.000+11:00"},"updated":{"$t":"2016-03-03T11:26:57.841+11:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"CFML"}],"title":{"type":"text","$t":"Reading and writing binary to a mySQL database with ColdFusion"},"content":{"type":"html","$t":"Ever wanted to save an image to a database with ColdFusion?  I see this question asked quite often.  I don't have a need to do this but I mocked up a quick demo or reading and writing binary data to and from a mySQL database.\u003Cbr \/\u003E\u003Cbr \/\u003EThe code is very simple.  I read the binary data from a image.  Write it to a database, read it back out and write it to the browser.  I also rotate the image to show the result from the database acts just like any other image data.\u003Cbr \/\u003E\u003Cbr \/\u003EYou might note I made use of 2 great new features of ColdFusion 9.\u003Cbr \/\u003E\u003Cbr \/\u003E1.  Data source specific to the application.  I no longer need to specify a datasource in my cfquery tags as I have this setup in Application.cfc.\u003Cbr \/\u003E\u003Cbr \/\u003E2.  On insert ColdFusion can return the autoincrement id value of the record just inserted.  Eg in SQL server select @@identity does the same thing.  This was available in \u003Ca href=\"http:\/\/tutorial9.learncf.com\/\" target=\"_blank\"\u003ECF8\u003C\/a\u003E but it was lacking and was different depending on the database type.\u003Cbr \/\u003E\u003Cbr \/\u003EIn ColdFusion 9 the old values still work ( so code wont break ) but we also can now use queryResult.generatedKey.\u003Cbr \/\u003E\u003Cbr \/\u003EI always try include a working demo: \u003Ca href=\"http:\/\/railo.kukiel.net\/imageinsert\/\" target=\"_blank\"\u003E http:\/\/railo.kukiel.net\/imageinsert\/\u003C\/a\u003E\u003Cbr \/\u003E\u003Cbr \/\u003EHere is the CF Code:\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Ciframe src=\"http:\/\/pastebin.com\/embed_iframe.php?i=RfXfAEv9\" style=\"border: none; height: 500px; width: 100%;\"\u003E\u003C\/iframe\u003E Here is a sample to create the mySQL table:\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Ciframe src=\"http:\/\/pastebin.com\/embed_iframe.php?i=JRRdn5XG\" style=\"border: none; width: 100%;\"\u003E\u003C\/iframe\u003E  \u003Cbr \/\u003EAlso note as this gets alot of people that by default CFadmin only allows 64k to be passed from CF to the database.  You will probably need to increase this value.  For this example I just added 2 extra 0's ( 6.4meg ).  If you don't half the image will be inserted and you will be confused as to what the image ( or other binary files ) are corrupted.\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"http:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/SxUvCqgpX4I\/AAAAAAAAB_o\/LdkT_01XT2w\/s1600\/Capture.JPG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" src=\"https:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/SxUvCqgpX4I\/AAAAAAAAB_o\/LdkT_01XT2w\/s400\/Capture.JPG\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/blog.kukiel.net\/feeds\/1879252002572218250\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/blog.kukiel.net\/2009\/12\/reading-and-writing-binary-to-mysql.html#comment-form","title":"23 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/1879252002572218250"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/1879252002572218250"},{"rel":"alternate","type":"text/html","href":"http:\/\/blog.kukiel.net\/2009\/12\/reading-and-writing-binary-to-mysql.html","title":"Reading and writing binary to a mySQL database with ColdFusion"}],"author":[{"name":{"$t":"Paul Kukiel"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/09506704719956887151"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"https:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/SxUvCqgpX4I\/AAAAAAAAB_o\/LdkT_01XT2w\/s72-c\/Capture.JPG","height":"72","width":"72"},"thr$total":{"$t":"23"}},{"id":{"$t":"tag:blogger.com,1999:blog-8359992897615744154.post-6489285971610609014"},"published":{"$t":"2009-11-09T08:22:00.002+11:00"},"updated":{"$t":"2016-03-03T11:26:19.181+11:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"CFML"}],"title":{"type":"text","$t":"ColdFusion 9 on GlassFish"},"content":{"type":"html","$t":"\u003Cdownload 8=\"\" 9.=\"\" coldfusion=\"\" or=\"\"\u003E\u003C\/download\u003E\u003Cbr \/\u003EDownload and install java \u003Cb\u003Esdk \u003C\/b\u003E( I used 1.6.17 ) ( note you need the JDK not JRE )\u003Cbr \/\u003EDownload glassFish\u003Cbr \/\u003EDownload ColdFusion 8 or 9\u003Cbr \/\u003EDownload Apache\u003Cbr \/\u003E\u003Cbr \/\u003EI used Windows Server 2008 64bit but the process is the same for 32bit or Win 2k3.\u0026nbsp; It's also ( obviously ) different on linux or unix but not majorly. \u003Cbr \/\u003E\u003Cbr \/\u003EWhen installing glassFish did not detect java home correctly so I provided the location via the cmd line. \u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"http:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/SvcqIWIww_I\/AAAAAAAABxE\/yj3SweGmQfk\/s1600-h\/1.JPG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" src=\"https:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/SvcqIWIww_I\/AAAAAAAABxE\/yj3SweGmQfk\/s640\/1.JPG\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cbr \/\u003EThe install is very straight forward I did not select anything unusual and just clicked through:\u003Cbr \/\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"http:\/\/2.bp.blogspot.com\/_hxgUC3p3PNI\/SvcqclcWIZI\/AAAAAAAABxM\/YLe_WqgdElw\/s1600-h\/2.JPG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" src=\"https:\/\/2.bp.blogspot.com\/_hxgUC3p3PNI\/SvcqclcWIZI\/AAAAAAAABxM\/YLe_WqgdElw\/s400\/2.JPG\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: left;\"\u003E\u003Cbr \/\u003E\u003C\/div\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: left;\"\u003EOnce glassFish was installed I started the server:\u003C\/div\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: left;\"\u003E\u003Cbr \/\u003E\u003C\/div\u003E\u003Cbr \/\u003E\u003Cdiv style=\"text-align: center;\"\u003E\u003Ca href=\"http:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/Svcq1o5X30I\/AAAAAAAABxc\/qsv3HNGZUzk\/s1600-h\/3.JPG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" src=\"https:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/Svcq1o5X30I\/AAAAAAAABxc\/qsv3HNGZUzk\/s400\/3.JPG\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cbr \/\u003EThen browse to:\u0026nbsp; http:\/\/127.0.0.1:4848 to get to the admin console.\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"http:\/\/2.bp.blogspot.com\/_hxgUC3p3PNI\/SvcrBvqehSI\/AAAAAAAABxk\/vWyRAdDVFTk\/s1600-h\/4.JPG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" src=\"https:\/\/2.bp.blogspot.com\/_hxgUC3p3PNI\/SvcrBvqehSI\/AAAAAAAABxk\/vWyRAdDVFTk\/s400\/4.JPG\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cbr \/\u003EI choose to leave the admin with no authentication so it will just load to the console.\u003Cbr \/\u003E\u003Cbr \/\u003EBefore you look at the console we will need to create a ColdFusion war.\u0026nbsp; Run the ColdFusion installer and select \"JEE Configuration\"\u003Cbr \/\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"http:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/SvcrapSTOuI\/AAAAAAAABxs\/NghwP2dtal8\/s1600-h\/4.5.JPG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" src=\"https:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/SvcrapSTOuI\/AAAAAAAABxs\/NghwP2dtal8\/s640\/4.5.JPG\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cbr \/\u003EThis will produce the war file ready for deployment.\u0026nbsp; For me the output was c:\\coldFusion9\\cfusion.war\u003Cbr \/\u003E\u003Cbr \/\u003ENow go back to the control panel.\u0026nbsp; Select \"Applications\" from the menu.\u0026nbsp; Then select \"Deploy\".\u0026nbsp; Choose a file from the local file system and leave the name as cfusion.\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"http:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/Svcr0pA3-PI\/AAAAAAAABx0\/HOHsEcYR3GQ\/s1600-h\/4.9.JPG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" src=\"https:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/Svcr0pA3-PI\/AAAAAAAABx0\/HOHsEcYR3GQ\/s640\/4.9.JPG\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cbr \/\u003EOnce the application is deployed we can launch it by clicking launch button and you will see:\u003Cbr \/\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"http:\/\/1.bp.blogspot.com\/_hxgUC3p3PNI\/SvcwcCoLIlI\/AAAAAAAABx8\/KWB_HxSZq7k\/s1600-h\/6.JPG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" src=\"https:\/\/1.bp.blogspot.com\/_hxgUC3p3PNI\/SvcwcCoLIlI\/AAAAAAAABx8\/KWB_HxSZq7k\/s640\/6.JPG\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Cbr \/\u003E\u003C\/div\u003E404 error's.\u0026nbsp; This is because there are no .cfm files if you went to \/CFID\/administrator you would would be at the CFADMIN.\u003Cbr \/\u003E\u003Cbr \/\u003EI'll skip the CFADMIN and make a index.cfm:\u003Cbr \/\u003E\u003Cbr \/\u003EContaning:\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Ctextarea class=\"java\" cols=\"60\" id=\"code\" name=\"code\" rows=\"8\"\u003E\u003Cbr \/\u003E \u003Ccfdump var=\"#server#\" \/\u003E \u003Cbr \/\u003E\u003C\/textarea\u003E\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"http:\/\/4.bp.blogspot.com\/_hxgUC3p3PNI\/SvcwsG1ms_I\/AAAAAAAAByE\/TYSTCgdt8fU\/s1600-h\/7.JPG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" src=\"https:\/\/4.bp.blogspot.com\/_hxgUC3p3PNI\/SvcwsG1ms_I\/AAAAAAAAByE\/TYSTCgdt8fU\/s400\/7.JPG\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cbr \/\u003EReload the Original page that was launched by clicking \"Launch\"\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"http:\/\/2.bp.blogspot.com\/_hxgUC3p3PNI\/SvcxFN901GI\/AAAAAAAAByM\/GPXHLzNmLlg\/s1600-h\/8.JPG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" src=\"https:\/\/2.bp.blogspot.com\/_hxgUC3p3PNI\/SvcxFN901GI\/AAAAAAAAByM\/GPXHLzNmLlg\/s640\/8.JPG\" \/\u003E\u003C\/a\u003E\u003C\/div\u003EAnd ColdFusion 9 is running on GlassFish.\u003Cbr \/\u003E\u003Cbr \/\u003EThis is on port 8080 but I want it to run behind apache on port 80 without the \/cfusion\u003Cbr \/\u003E\u003Cbr \/\u003EMake sure IIS is not running. Install Apache.\u0026nbsp; Apache for windows come with all the modules you're likely to need but most are commented out.\u0026nbsp; Test to make sure Apache is runnign and http:\/\/127.0.0.1 should the standard message \"It works\".\u003Cbr \/\u003E\u003Cbr \/\u003ENow we will setup the proxy.\u003Cbr \/\u003E\u003Cbr \/\u003EAround line 110 of httpd.conf uncomment 2 modules mod_proxy.so and mod_proxy_connect.so\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Ctextarea class=\"java\" cols=\"60\" id=\"code\" name=\"code\" rows=\"6\"\u003ELoadModule proxy_module modules\/mod_proxy.so\u003Cbr \/\u003E#LoadModule proxy_ajp_module modules\/mod_proxy_ajp.so\u003Cbr \/\u003E#LoadModule proxy_balancer_module modules\/mod_proxy_balancer.so\u003Cbr \/\u003ELoadModule proxy_connect_module modules\/mod_proxy_connect.so\u003C\/textarea\u003E\u003Cbr \/\u003E\u003Cbr \/\u003EAlso un-comment\u003Cbr \/\u003E\u003Ctextarea class=\"java\" cols=\"60\" id=\"code\" name=\"code\" rows=\"2\"\u003E\u003Cbr \/\u003E# Virtual hosts\u003Cbr \/\u003EInclude conf\/extra\/httpd-vhosts.con\u003C\/textarea\u003E\u003Cbr \/\u003E\u003Cbr \/\u003EOpen {apacheInstallDir}\\conf\\extrahttpd-vhosts.conf\u003Cbr \/\u003E\u003Cbr \/\u003Ecreate a new vhostBlock\u003Cbr \/\u003E\u003Ctextarea class=\"java\" cols=\"60\" id=\"code\" name=\"code\" rows=\"10\"\u003E\u003Cvirtualhost *:80\u003E\u003Cbr \/\u003EServerName cf9gf\u003Cbr \/\u003EProxyRequests Off\u003Cbr \/\u003E\u003Cproxy *\u003E\u003Cbr \/\u003EOrder deny,allow\u003Cbr \/\u003EAllow from all\u003Cbr \/\u003E\u003C\/Proxy\u003E\u003Cbr \/\u003EProxyPass \/ http:\/\/127.0.0.1:8080\/cfusion\/\u003Cbr \/\u003EProxyPassReverse \/ http:\/\/127.0.0.1:8080\/cfusion\/\u003Cbr \/\u003E\u003C\/VirtualHost\u003E\u003C\/textarea\u003E\u003Cbr \/\u003E\u003Cbr \/\u003EI created a dummy entry in the Windows host file so\u003Cb\u003E http:\/\/cf9gf \u003C\/b\u003Eresolves locally.  I'll be using this as the test domain.\u003Cbr \/\u003E\u003Cbr \/\u003ERestart apache and look for errors.\u003Cbr \/\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"http:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/Svcp26Em52I\/AAAAAAAABw8\/AJQ0ujxn9VQ\/s1600-h\/9.JPG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" src=\"https:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/Svcp26Em52I\/AAAAAAAABw8\/AJQ0ujxn9VQ\/s320\/9.JPG\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cbr \/\u003E\u003Cbr \/\u003EIf there are no errors you should now be ready to proxy from apache to glassFish on port 80.\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"http:\/\/4.bp.blogspot.com\/_hxgUC3p3PNI\/Svcp0LJ6ZGI\/AAAAAAAABw0\/5E2YehGef7M\/s1600-h\/10.JPG\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" src=\"https:\/\/4.bp.blogspot.com\/_hxgUC3p3PNI\/Svcp0LJ6ZGI\/AAAAAAAABw0\/5E2YehGef7M\/s640\/10.JPG\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cbr \/\u003EDone.\u003Cbr \/\u003E\u003Cbr \/\u003ENow GlashFish is no longer listed here: \u003Ca href=\"http:\/\/www.adobe.com\/products\/coldfusion\/systemreqs\/\" target=\"_blank\"\u003Ehttp:\/\/www.adobe.com\/products\/coldfusion\/systemreqs\/\u003C\/a\u003E but it still works fine.\u003Cbr \/\u003E\u003Cbr \/\u003EAlso note the \/flex2gateway works fine aswell."},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/blog.kukiel.net\/feeds\/6489285971610609014\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/blog.kukiel.net\/2009\/11\/coldfusion-9-on-glassfish.html#comment-form","title":"43 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/6489285971610609014"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/6489285971610609014"},{"rel":"alternate","type":"text/html","href":"http:\/\/blog.kukiel.net\/2009\/11\/coldfusion-9-on-glassfish.html","title":"ColdFusion 9 on GlassFish"}],"author":[{"name":{"$t":"Paul Kukiel"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/09506704719956887151"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"https:\/\/3.bp.blogspot.com\/_hxgUC3p3PNI\/SvcqIWIww_I\/AAAAAAAABxE\/yj3SweGmQfk\/s72-c\/1.JPG","height":"72","width":"72"},"thr$total":{"$t":"43"}},{"id":{"$t":"tag:blogger.com,1999:blog-8359992897615744154.post-4779150468257019791"},"published":{"$t":"2009-11-07T04:21:00.000+11:00"},"updated":{"$t":"2016-03-03T12:00:31.431+11:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"CFML"},{"scheme":"http://www.blogger.com/atom/ns#","term":"SQL"}],"title":{"type":"text","$t":"ColdFusion md5 hash directy in MSSQL"},"content":{"type":"html","$t":"Ever needed to compare a ColdFusion hash() directly in MS SQL? I did today and I knew I had accomplished this before but forgot how to do it. Searching the net and twitter I came to some dead end or longish solutions. I knew \u003Ca href=\"http:\/\/lanctr.com\/\" target=\"_blank\"\u003ESteve Good\u003C\/a\u003E and I worked this out once before but I also remember there being an easier way.\u003Cbr \/\u003E\u003Cbr \/\u003EWell there is and here is where I took the solution from: \u003Ca href=\"http:\/\/orangepips.instantspot.com\/blog\/Database\"\u003Ehttp:\/\/orangepips.instantspot.com\/blog\/Database\u003C\/a\u003E\u003Cbr \/\u003E\u003Cbr \/\u003EThe funny thing is I found this nearly a year ago and actually commented on the post just forgot all about it.\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Ctextarea class=\"cf\" cols=\"60\" id=\"code\" name=\"code\" rows=\"8\"\u003E\u003Cbr \/\u003E\u003Ccfquery datasource=\"SQL\"\u003E\u003Cbr \/\u003E  insert \u003Cbr \/\u003E  into    Contact\u003Cbr \/\u003E      ( firstName, firstNameHash )\u003Cbr \/\u003E  values  ( \u003Ccfqueryparam cfsqltype=\"cf_sql_varchar\" value=\"Paul\" \/\u003E,\u003Cbr \/\u003E         \u003Ccfqueryparam cfsqltype=\"cf_sql_varchar\" value=\"#hash('Paul')#\" \/\u003E )\u003Cbr \/\u003E\u003C\/cfquery\u003E\u003Cbr \/\u003E\u003C\/textarea\u003E\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Ctextarea class=\"sql\" cols=\"60\" id=\"code\" name=\"code\" rows=\"8\"\u003E\u003Cbr \/\u003Eselect   id, firstName, firstNameHash, upper(right(master.dbo.fn_varbintohexstr(HashBytes('MD5', firstName)), 32)) AS sqlHash\u003Cbr \/\u003Efrom     Contact\u003Cbr \/\u003E\u003C\/textarea\u003E \u003Cbr \/\u003E\u003Cbr \/\u003EThe result:\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cimg src=\"http:\/\/farm3.static.flickr.com\/2512\/4080972894_196067980d_o.jpg\" \/\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/blog.kukiel.net\/feeds\/4779150468257019791\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/blog.kukiel.net\/2009\/11\/coldfusion-md5-hash-directy-in-mssql.html#comment-form","title":"7 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/4779150468257019791"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/4779150468257019791"},{"rel":"alternate","type":"text/html","href":"http:\/\/blog.kukiel.net\/2009\/11\/coldfusion-md5-hash-directy-in-mssql.html","title":"ColdFusion md5 hash directy in MSSQL"}],"author":[{"name":{"$t":"Paul Kukiel"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/09506704719956887151"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"thr$total":{"$t":"7"}},{"id":{"$t":"tag:blogger.com,1999:blog-8359992897615744154.post-3138015662479516697"},"published":{"$t":"2009-10-28T07:28:00.002+11:00"},"updated":{"$t":"2016-03-03T11:26:04.182+11:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"CFML"}],"title":{"type":"text","$t":"ColdFusion 9 on Windows server 2008 64bit"},"content":{"type":"html","$t":"I put this together almost immediately after CF9 was released but even before then I had some people contact me to ask how CF9 runs on both Windows 7 and Windows server 2008.  \u003Cbr \/\u003E\u003Cbr \/\u003EAnswer?\u003Cbr \/\u003E\u003Cbr \/\u003EIt works fine on both.\u003Cbr \/\u003E\u003Cbr \/\u003EIf you have ever tried to install ColdFusion 7\/8 on Windows Vista after Service pack 1, Windows 7 or Windows server 2008 with IIS at one stage you have undoubtedly come across this:\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cb\u003E\"HTTP Error 404.3 - Not Found\u003Cbr \/\u003EThe page you are requesting cannot be served because of the extension configuration.\u003Cbr \/\u003EIf the page is a script, ad a handler.  If the files should be downloaded, add a MIME map.\"\u003C\/b\u003E\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cimg alt=\"ColdFusion 9 error\" src=\"http:\/\/farm3.static.flickr.com\/2486\/4029951585_e259d86611_o.jpg\" height=\"500\" width=\"650\" \/\u003E\u003Cbr \/\u003E\u003Cbr \/\u003EWell with CF9 and Windows Server 2008 your going to get the same issue.  It's actually an easy fix and almost identical to the Windows 7 \/ Vista solution just visually a little different here is a walk through of the installation.  Note this is CF9 64 bit on Windows Server 2008 64bit and just in case you missed it 64bit is now available in ColdFusion standard:\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Ca href=\"http:\/\/vc.kukiel.net\/cf9win2k8\/\" target=\"_blank\"\u003E\u003Cbr \/\u003EHigh Quality video click here\u003C\/a\u003E.\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cobject height=\"385\" width=\"480\"\u003E\u003Cparam name=\"movie\" value=\"http:\/\/www.youtube.com\/v\/JXIYZuTXajs\u0026hl=en\u0026fs=1\u0026hd=1\"\u003E\u003C\/param\u003E\u003Cparam name=\"allowFullScreen\" value=\"true\"\u003E\u003C\/param\u003E\u003Cparam name=\"allowscriptaccess\" value=\"always\"\u003E\u003C\/param\u003E\u003Cembed src=\"http:\/\/www.youtube.com\/v\/JXIYZuTXajs\u0026hl=en\u0026fs=1\u0026hd=1\" type=\"application\/x-shockwave-flash\" allowscriptaccess=\"always\" allowfullscreen=\"true\" width=\"480\" height=\"385\"\u003E\u003C\/embed\u003E\u003C\/object\u003E\u003Cbr \/\u003E\u003Cbr \/\u003EBTW this will also work for CF8.\u003Cbr \/\u003E\u003Cbr \/\u003EOh and if your trying to run CF9 32 bit on Windows server 2008 64bit again don't forget 64 bit is part of standard."},"link":[{"rel":"replies","type":"application/atom+xml","href":"http:\/\/blog.kukiel.net\/feeds\/3138015662479516697\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"http:\/\/blog.kukiel.net\/2009\/10\/coldfusion-9-on-windows-server-2008.html#comment-form","title":"33 Comments"},{"rel":"edit","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/3138015662479516697"},{"rel":"self","type":"application/atom+xml","href":"http:\/\/www.blogger.com\/feeds\/8359992897615744154\/posts\/default\/3138015662479516697"},{"rel":"alternate","type":"text/html","href":"http:\/\/blog.kukiel.net\/2009\/10\/coldfusion-9-on-windows-server-2008.html","title":"ColdFusion 9 on Windows server 2008 64bit"}],"author":[{"name":{"$t":"Paul Kukiel"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/09506704719956887151"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"thr$total":{"$t":"33"}}]}});