After looking at Dan Vega’s series of posts on CFGRID usage, I decided to put together an example of CFGRID with a full CRUD functionality. ColdFusion 8 has introduced the new HTML format CFGRID which uses AJAX behind the scenes. I quite like the features it offers and I think with EXT framework behind the scenes, there are some nice things that can be done with it. Dan has already covered a lot of these areas and is doing a great job I think in writing these posts up. More »
In an attempt to do something with Coldfusion’s .NET functionality, I tried to consume any existing .NET component to do something useful with it. Ideally, in order for this exercise to be really termed as useful, I should have been writing my own .NET component and then consume it in CF, but I would leave that exercise for later on, given the fact that my .NET skills are not so good and I haven’t really done a lot of .NET except a few tidbits here and there.
So, having said that, I decided to do something with Excel and started looking for a publicly available .NET component for Excel. Although there are a lot of ways to do that already, via CF, as described by Charlie Arehart (which happens to be a really informative list), I still wanted to do it via a .NET component just for the sake of doing it.
More »
The issue is really weird. What’s happening is that whenever <cfdump> tag is used anywhere in the code, it throws an error like this.
Permission denied for creating Java object: coldfusion.util.DumpHelper. Access to Java objects in the ColdFusion package has been disabled by the administrator
The server is CF8 with access to internal Java Objects disabled. I have checked all the application.cfm files that can possibly be called and there are no Java objects being used anywhere. It might be worth mentioning that there is a CFC which is being used on the server which uses some Java objects but those Java objects are not the CF’s internal objects, so that should be fine and that CFC works just fine when called.
I have spent a few hours trying to figure this out and I am at a loss as to what’s going on with <cfdump> here. I have tried to reproduce the error to get to the bottom of it but there is no consistency in its behaviour. Here is what I did :-
- Keep the access to Java Objects disabled and restart CF.
- Create a Java Object that uses internal CF object and get a ‘Permissions denied’ error as expected.
- Now comment that line of code which uses the internal CF object, and use a simple <cfdump> tag that dumps any var.
- Unexpectedly, It would throw the error I stated above (not always though - it did this just once, the first time)
- Enable access to internal Java objects and the error is gone, as expected.
- Disable the access again and you might see the error again.
- Repeat the whole exercise and you might see the error thrown by cfdump at Step 4.
Anyone came across this issue ever? Any info would be appreciated. This is a very useful tag and is used all the time while coding and its a big issue when it doesn’t work.
I have always used INFORMATION_SCHEMA to some extent in some way or the other. Its quite handy to get information about database objects. This morning, I saw a nice article about this on SqlServerCentral. The author’s name is Mike and he does a pretty good job in explaining the concepts. There is also a stored procedure to search a specific value database-wide.
I recently found out that INFORMATION_SCHEMA is not only Sql Server specific (which is what I used to think). MySql supports this as well. Details here.
I am a bit late in blogging about this as the news is all over the blogospher by now but its Monday morning and I just found this out.
Adobe have released Flex 3.0 and AIR 1.0 . This was a much awaited news as far as I know. The good thing is that they have setup a Adobe Open Source Flex SDK wiki which looks good as well.
And because the SDK is open source, the code can be downloaded via SVN from here.
http://opensource.adobe.com/svn/opensource/flex/sdk
Thanks to Adobe for all this and I am very excited about working with Flex/AIR and building RIA apps that look and work great at the same time.
I have been looking for these little gems recently and everytime I happen to find something new. Although, I dont blog about everything I find, this one is worth it I think.
Normally in order to validate an IP address, we would use some kind of regular expression but Coldfusion has an inbuilt class for validating IP addresses. Both the v4 and v6 addresses. Not an IP expert, have a look here for an explanation of what they exactly mean. So, here is the code :- More »
I was asked this question last night by someone who had recently upgraded from CF5 to CF8. Coldfusion suddenly started throwing these errors on almost all the websites on the server.
“corrupt table null”
There was no consistency in how the errors were being thrown, in a way that refresh the page and error is gone and refresh the page and there it is again. A restart of CF would help for a few hours but then the error would come again. More »
I was reading some SQL tips and found this small but quite handy tip. If you have a boolean column in your database which holds values like 0 and 1 , you can modify your Select queries to represent that data as a Yes or No by doing this.
The trick is if the column holds a value of 0, the SQL would read
SUBSTRING(’YesNo’, 4, 3) which returns ‘No’
And if the Column has a value of 1, it becomes SUBSTRING(’YesNo’, 1, 3) which returns ‘Yes’.
I like it. This was part of a bigger article found here.
Just found this little thingy which according to me is quite impressive.
Now what that does is takes a file from your local folder and applies colored coding to it. Not the best colored code but a lot better than the heavy Regular expression.
Try it out !
If you are using Subversion, you might have come across this issue. Multiple developers working on a set of files and committing them without any comments. If you decide to force comments on every commit, here is a little pre-commit hook script that will do the job. Just to be clear, a pre-commit script is fired when the user hits the ‘OK’ button on the commit dialog box.
This script would need to be under /{repository-location}/hooks/. There are some template scripts already in there and this one is probably a slight modification of one of those samples in there. More »