OK, so I've been working through build a new blog platform using the new ColdFusion 9 ORM setup, and I'm really impressed with how much of the basics it handles for you, but I'm starting to get into stuff thats more than just a simple CRUD action, and I'm finding that I've no idea how to make the ORM or HQL get me the results I need. Perhaps you can help me figure out what I need to do.
I'm trying to get a feel for the new ColdFusion 9 ORM setup, and I ran into an error message that I'd not seen before stating that "[Macromedia][SQLServer JDBC Driver][SQLServer]'FK3498A0CE621DF1' is not a constraint." This isn't too daunting, since I'm used to weird SQL errors, but when I refreshed the error I got back "[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot find the object "post" because it does not exist or you do not have permissions." instead.Take a look at the particulars, and see if you can help me out.
I ran across this bit of CF code in a project that I'm working on upgrading, and I was so completely confused by the it that I thought I might throw it up here to see what people think of it.
This post isn't anything new, but I felt that I should document that yet another person has wasted some of their life struggling to get CF working on an IIS7 machine. I first ran into this problem about 6 months ago when trying to install CF8 on Windows Server 2008 (64-bit), and we had so many problems doing it that the server was rolled back to Windows Server 2003 (32-bit) to get around it. Today I had to get CF9 installed on a Vista, and had to deal with the same issues all over again. Luckily the solution was simpler this time, and involved only one reinstall of CF, rather than 5 and a full wipe of an OS like last time.
Why hasn't this been fixed by now?
Oh, and for those needing a solution, I found mine at Dale Fraser's Blog.
As some of you might know, my work place is no stranger to odd server problems, such as instances just wanting to return 503 errors. Today I have a new one: one of our applications refuses to run at full speed if its in anything other than the default instance.
I ran into an interesting situation this morning that didn't have an obvious answer. I needed to create a zip with a few specific files out of a directory with lots of possible files. The problem is that <cfzip /> is designed to work against whole directories, so at first I kept thinking that I'd have to make a temporary directory, move the files to it, and then zip the directory, but a little more persistence found the right answer.
I'm Jon Hartmann and I'm a Javascript fanatic, UX/UI evangelist and former ColdFusion master. I blog about mysterious error messages, user interface design questions, and all things baffling and irksome about programming for the web.