Moonbase7 Weblog

Moonbase7 Weblog http://moonbase7.com The weblog of Moonbase7 en-us Copyright 2010 Moonbase7 http://backend.userland.com/rss/ Mon, 06 Sep 2010 01:47:42 PST Car plus Droid equals fun <object width='400' height='265'> <param name='allowfullscreen' value='true' /> <param name='allowscriptaccess' value='always' /> <param name='movie' value='http://vimeo.com/moogaloop.swf?clip_id=12991976&server=vimeo.com&show_title=1&show_byline=1&show_portrait=0&color=c9ff23&fullscreen=1' /><embed src='http://vimeo.com/moogaloop.swf?clip_id=12991976&server=vimeo.com&show_title=1&show_byline=1&show_portrait=0&color=c9ff23&fullscreen=1' type='application/x-shockwave-flash' allowfullscreen='true' allowscriptaccess='always' width='400' height='265'></embed></object> <a href='http://vimeo.com/12991976'>Crazy Car</a> from <a href='http://vimeo.com/user3447719'>Charles Kaufmann</a> on <a href='http://vimeo.com'>Vimeo</a>. This is taken by a Motorola Droid taped to the top of a remote control car. Just need to find a cool video conferencing app to load on the Droid so I can drive it remotely! http://moonbase7.com/index.cfm?request=weblog&id=248&wid=40 Charles Thu, 01 Jul 2010 02:50:51 PST coreForms Blog Posts Moved I have moved all the coreForms update posts to a different blog.  You can find it on the CompositeWeb's <a href='http://compositeweb.com/index.cfm?request=Weblog&id=837'>main blog</a>. http://moonbase7.com/index.cfm?request=weblog&id=248&wid=35 Charles Sun, 24 Jan 2010 12:10:55 PST How to find large files on a Mac I was looking for all the really large files on my Mac and couldn't figure out how to do it.  After searching the web, I found this easy solution. When you have no other windows open click on cmd and F. This should open the finder window. http://moonbase7.com/index.cfm?request=weblog&id=248&wid=32 Charles Fri, 08 Jan 2010 23:05:31 PST Walking in the Assabet River NWR Last weekend the family and I went for a walk in the <a href='http://www.fws.gov/northeast/assabetriver/index.html'>Assabet River National Wildlife Refuge</a>.  It was snowy but nice.  We hadn't been there since the summer and were impressed by all the work on the road that has been completed (even though it was under snow).  We had always hoped that they were going to open up the roads to bike traffic and we checked the signs again, and they in fact did open it up. You are now allowed to ride your bike on the roads!   http://moonbase7.com/index.cfm?request=weblog&id=248&wid=31 Charles Thu, 07 Jan 2010 03:47:17 PST First Hosted Intranet Video I completed my first video for CompositeWeb this past weekend.  It is an overview of CompositeWeb's <a href='http://www.compositeweb.com'>Hosted Intranet</a> product.  I used Jing to record it and was happy with the results although it took a lot longer then I had expected it to. <object height='340' width='560'> <param value='http://www.youtube.com/v/-Ru8uKixDnM&hl=en_US&fs=1&rel=0' name='movie' /> <param value='true' name='allowFullScreen' /> <param value='always' name='allowscriptaccess' /><embed height='340' width='560' allowfullscreen='true' allowscriptaccess='always' type='application/x-shockwave-flash' src='http://www.youtube.com/v/-Ru8uKixDnM&hl=en_US&fs=1&rel=0'></embed></object> If you have any feedback let me know in the comments.   http://moonbase7.com/index.cfm?request=weblog&id=248&wid=30 Charles Mon, 28 Dec 2009 11:25:29 PST Viewing hidden files on your Mac For most people this is probably not pertinent as you don't want to be deleting any of your hidden system files.  I had an issue the other day were I needed to delete some svn information off of my computer before being able to check it in. I had copied a bunch of files from one subversion location to a new one using finder and caused a bunch of issues with the new subversion site. In order to delete out the old subversion data, you need to enable the viewing of the hidden files, then delete all the .svn directories, then check everything in. To view hidden files, open up terminal editor and type in this: <pre><code>defaults write com.apple.finder AppleShowAllFiles TRUE killall Finder</code></pre> To hide all the hidden files after you are done: <pre><code>defaults write com.apple.finder AppleShowAllFiles FALSE killall Finder</code></pre> <code>Good luck.</code> http://moonbase7.com/index.cfm?request=weblog&id=248&wid=29 Charles Tue, 27 Oct 2009 17:55:25 PST Coldfusion Query of Queries Sort Order Here's another item that I am note sure I knew before, but now I do.  When you are running a query of queries and trying to do a sort on it, the one thing you have to remember is that the field names are case sensitive. So what you need to do is cfdump the query you are using in the query of queries and copy the field names that show up exactly as shown.  Then it should run just fine. http://moonbase7.com/index.cfm?request=weblog&id=248&wid=28 Charles Sun, 27 Sep 2009 13:17:58 PST Personal Blimp Idea I was surfing around YouTube and <a href='http://www.youtube.com/watch?v=RecckjgLyqo'>found this video</a> of a personal airship!  How cool would that be.  Anyway, the blimp is so delicate you could not use it outside.  But then I got to thinking that this would be an awesome revenue generator for indoor stadiums. I have no idea how much time stadiums are not used, but I bet they could get a bunch of people to pay $50 per 30 minutes to fly one of these blimps around.  I sure would.  And they would be doing this on the days that the stadiums are not generating any revenue. So if anybody owns a stadium, please look into it and let me know where the reservation form is located so I can sign-up! http://moonbase7.com/index.cfm?request=weblog&id=248&wid=27 Charles Sat, 12 Sep 2009 13:24:33 PST RPXnow and Coldfusion I was recently integrating OpenID into my SaaS Intranet offering over at <a href='http://www.compositeweb.com'>CompositeWeb</a>.  I started working with the opensource project <a href='http://openid.riaforge.org/'>OpenID</a> at riaforge.  It worked great, but then I found the <a href='https://rpxnow.com/'>RPXnow</a> site and thought it would provide a lot more flexibility in the future and provide for an easier to maintain interface. I didn't find any information on how to implement it with coldfusion so I thought I would post what I figured out.   http://moonbase7.com/index.cfm?request=weblog&id=248&wid=26 Charles Sat, 12 Sep 2009 12:33:53 PST cfqueryparam and NULL I was recently adding some features to my CMS system and came accross a feature of cfqueryparam that I had not used in a while but is really nice when you need it.  When doing an insert or update query for an integer field you can specify the Null attribute of the cfqueryparam tag. Here is an example: <pre> <cfqueryparam cfsqltype="cf_sql_integer" value="#form.duration#" NULL="#NOT len(form.duration)#"> </pre> So what this is doing is testing if there is any value in the form.duration field, and if there is nothing there, insert a NULL.  If there is something there is just inserts the field value normally.   http://moonbase7.com/index.cfm?request=weblog&id=248&wid=24 Charles Sat, 25 Jul 2009 03:22:56 PST Coldfusion query data without a database I am currently redoing the help files for coreforms.  I have to totally redo them because I have added a bunch of new features, and I don't think the current version is that useful.  You kind of know that your documentation needs changing when the author of whatever you are trying to document has a hard time figuring them out. So the solution I am working on needs a database so I can organize the documentation better.  The problem is that I do not want to require that people who want to view the documentation need to have a database connection and load a bunch of tables onto their server.  So I am trying some static ways to create coldfusion datasources. The first way is to manually build out the query using coldfusion's queryNew, queryAddRow and querySetCell tags. <pre> <cfset get_format = queryNew("name,description,status,attributes")> <cfset queryAddRow(get_format)> <cfset querySetCell(get_format,"name","text")> <cfset querySetCell(get_format,"description","general text field, same features as an html text field")> <cfset querySetCell(get_format,"status","A")> <cfset querySetCell(get_format,"attributes","3")> <cfset queryAddRow(get_format)> <cfset querySetCell(get_format,"name","textarea")> <cfset querySetCell(get_format,"description","general textarea field, same features as an html text field")> <cfset querySetCell(get_format,"status","A")> <cfset querySetCell(get_format,"attributes","4")> </pre> This is ok for a small amount of rows, but I have another query that will hold all the attributes.  For this one I am going to use the basic concepts as the one above but build out a comma delimeted file first then loop through the data to create the query. <pre> <cfsavecontent variable="theData"> 1,fieldname,Yes,put the name of the query field,A,A 2,required,No,enter a Y if you need the field filled out,A,A 3,max,No,enter the total number of characters for a text field or a maximum date for a date field,A,S 4,cols,No,enter the number of columns for a textarea field just like the html attribute,A,S </cfsavecontent> <cfset theFields = "id,attributename,required,description,status,scope"> <cfset get_attributes = queryNew("#theFields#")> <cfloop list="#theData#" delimiters="#chr(10)##chr(13)#" index="ii"> <cfset queryAddRow(get_attributes)> <cfset loopcounter = 1> <cfloop list="#thefields#" index="jj"> <cfset querySetCell(get_attributes,"#jj#","#listgetat(ii,#loopcounter#)#")> <cfset loopcounter = loopcounter + 1> </cfloop> </cfloop> </pre>  Then all I have to do to get the query onto my page is to cfInclude the files that I put the above code on. http://moonbase7.com/index.cfm?request=weblog&id=248&wid=25 Charles Sat, 27 Jun 2009 13:22:49 PST Wiki Cheat Sheet I have been using a mediaWiki at work for documenting projects and have come up with some essential commands that I am putting here so I can easily reference them. Sections <pre> == level 1 == === level 2 === ==== level 3 ====</pre> Links <pre> [[ name of page| name of link ]]</pre> Bullets <pre> * bullet 1 ** sub bullet # numbered bullet ## sub numbered bullet</pre> Images <pre> [[Image:NameOfFile.gif|thumb|200px|The little caption you want with the image]]</pre> one of the cool things about the wiki is if you specify the image with the thumb attribute, it automatically puts it on the right and makes it clickable. Misc <pre> bold - <tt>'''bold'''</tt></pre>   http://moonbase7.com/index.cfm?request=weblog&id=248&wid=21 Charles Fri, 22 May 2009 15:10:10 PST Mac VPN Client error For all you out there who are running a Macbook Pro, using a Cisco VPN client and running into "Error 51: Unable to communicate with the VPN subsystem". Here is what you have to do to fix it.  Go to Applications > Utilities then open Terminal.  Once you get to the prompt, type in: <pre> sudo /System/Library/StartupItems/CiscoVPN/CiscoVPN restart </pre> You will be prompted to enter the password for your computer.  This procedure will restart the things that need to be restarted.  You should then be able to use your VPN client again. http://moonbase7.com/index.cfm?request=weblog&id=248&wid=20 Charles Wed, 13 May 2009 18:20:46 PST coreforms update I just posted an update to coreforms over at <a href='http://coreforms.riaforge.com'>riaforge</a>.  If you are interested in my forms solution, check it out. I added a couple of new features.  The first is the ability to prepopulate a form that allows for multiple check box selects.  The data could be coming from another query of just supply a comma delimeted list of values.  So as an example, say you are building a weblog form and you want to pull all the data for the post with query1 and you want to pull in all your post categories with another data.  This will allow you to tie the two into the same form so you can update the main post and the categories on the same form. I also added another customtag called "coredirections".  This allows you to add directions to a form at any point in the form if you are having the form build programatically (maketable = 'Y'). Hope you enjoy the changes.  If you have any suggestions let me know. http://moonbase7.com/index.cfm?request=weblog&id=248&wid=18 Charles Mon, 22 Dec 2008 03:42:43 PST SpaceShipTwo flight In case you missed the news over at <a href='http://www.space.com/missionlaunches/081221-whiteknighttwo-test.html'>Space.com</a>, SpaceShipTwo made its first flight today for one hour of air time. I have been following the Scaled Composites story for a long time and can't wait to see the first commercial flights. Hopefully the ticket price will come down soon so I can go for a ride. http://moonbase7.com/index.cfm?request=weblog&id=248&wid=17 Charles Sun, 21 Dec 2008 20:31:41 PST