I forgot a password to a mySQL datasource on my personal VPS. Not the end of the world I can log in to mySQL and reset it if I need but I knew these passwords were in new-datasource.xml in an encrypted format and was curious to see if I could decrypt that password. Turns out you can. I used this post as a staring point http://paulalkema.com/post.cfm/pull-a-list-of-all-coldfusion-datasources-along-with-username-and-passwords and while I was at it built this small app in case I need it in the future.

The new Railo installers are fantastic Jordan has done a great job.

I have a small VPS running demos for this blog it's running Railo. It's mostly for demos but also has a few small hobby sites.

I really don't need to allocate 512 to Railo I wanted to drop it to 256mb ram ( the VPS in Windows server 2008 r2 with only 512 ram which also runs .NET 4 and SQL Server Express ).

I search for a config file but there was none.

So here is how to change your jvm args and lower or raise the amount of ram you allocate to tomcat for Railo.

Click Start, Navagate to "Railo", click "Railo-Tomcat Servcice Control"

This will allow you to edit the options on the service.

Select the java tab

Then add jvm args and adjust the memory.

Screen shots:

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.

This 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.

I really expected this to just work:

mail.addPart( type="html", charset="utf-8", body=writedump(application) );

But it wont so here is the solution:

Here is the solution:



The other exception to my project was one cfc had to have a udf for cfexecute which also is not yet in cfscript.


Update.

To answer Steves question here is the code example.

You can just attach the report as a file attachment and specify the content.

If you need to increase the connection pool in a .NET application this is what you need to add to your webconfig file:

;max pool size=200

This would increase the connection pool to 200 ( from a default of 100 I believe )

This will be in the appsettings node as follows:

I have been working with jQGrid and upon adding a new record wasnted to jump to the last page of the grid upon successful save of a new entry without clicking the "last page" button. It really wasn't that had and Dave pointed me in the right direction with setParam.

Here is the code:


Working with jqGrid has been great but I'm also really looking forwards to the official jQuery grid.