I ran into something interesting and wondered if anyone had any insight on
it. I have noticed that variables set in application.cfm, in this case in
the request scope, do not work when pages are in an iFrame.
For example (request variables are set in application.cfm):
<CFQUERY datasource="#request.dsnName#" username="#request.dsnUser#"
password="#request.dsnPass#" name="tracks">
SELECT
*
FROM
myTable
ORDER BY
datestamp DESC
</CFQUERY>
This query runs fine on its own and the datasource, user, pass are set up in
the application.cfm file. However, if I use this same query on a page that
calls the page it is in from an iFrame as in: <iframe src="mypage.cfm"
width="133" height="320" scrolling="Auto" frameborder="0"></iframe>, it
won't run and throws an error:
[Macromedia][SQLServer JDBC Driver][SQLServer]SELECT permission denied on
object 'myTable', database 'myDataBase', owner 'dbo'.
When I hard code the datasource, username, password into the cfquery tag
instead of using the variables set in application.cfm, it then runs fine in
the iFrame tag. This is a band aid I guess but it would be nice to
understand why it is really happening.
Anyone have any insight?
Dusty
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
