CF Access query and HTML frames

Hello,

I'll start by saying that I am new to ColdFusion scripting. I am connecting to an Access database and executing a simple query. When I preview the page, home.cfm, it executes flawlessly. However, when the page is part of a frameset, it won't execute. Oddly enough, when I preview the frameset in IE6, the file itself (home.cfm) actually starts to download. I have not tested this on a "live" server. I am previewing locally on a Windows XP Pro machine running Windows IIS and ColdFusion MX 6.1 Dev. Please help!

Thanks,

Michael R

The page loads when you view it in its own window, but won't load in a frameset? That doesn't make any sense. CF has no idea whether the page is being used in a frame or not, it just gets a request for a page and returns the resulting output. I would start by looking at the source code for the frameset and confirm that you are using a valid URL. Copy the URL and use it in its own window to confirm that it works.

Michael,

When you view the file in the frameset, does everything come up blank or it is just not executing your queries.

If it is coming up blank, then you probably have some text or some kind of output in your frameset that is causing it not to be a frameset (framesets are real loners, they don't like anyone else in thier file).

Kitless| was of the mind that it shouldn't matter whether you output in a frame or not which is why this is so perplexing to me. Do you mean that I should be checking the source URL for the frame that is not loading in the frameset? If that is what you mean, I am able to load that frame by itself. I may be a bit confused.

Ebot| When I run the frameset, the frame which executes the CFquery does come up blank. It won't even load the error checking info, so i'm not sure if the query is even executing. Again, what's really odd is that the frame with the CF in it starts to "download," pops open a download dialog box?

You are correct, to ColdFusion it doesn't matter if the page is by itself or nested in a frameset that is 6 levels deep. All it knows is that it got an HTTP requset and it returns output in response to that. If you can load the URL that is the source for the frame in a browser window by itself, then CF is working correctly. If that frame won't populate correctly as part of the frameset, then the problem is absolutely somewhere in your frameset code and is totally independent of the CF server.

Framesets do not care if CFqueries are in the same file, however, if you have an object or text in the same file as a frameset, it will not load correctly. Basically, keep any tags that would go inside a form out of the file that holds your frameset.

Ebot & Kiteless| Thank you both for your replies. The probelm seems to lie somewhere in the configuration of my testing server. For some reason, the frameset cannot be viewed through my local testing server. However, if type the url into the browser, it works fine. Still a bit confused, but I think it requires more learning on my end. Thanks again.

Michael