You are right that ColdFusion does not have understanding of IFrames. I just experienced a similar issue and was conveying my shared experience.
Dusty,
I agree with putting the DSN in the application scope in your application.cfm. I did not know if you wanted to change the DSN during the programmatic course of the application. If it indeed does not change, Application seems the most logical spot for the DSN assignment.
Teddy
On 7/23/06, Dean H. Saxe <[EMAIL PROTECTED]> wrote:
Which would lead you to lock it... the REQUEST scope is fine for this
sort of data.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
"To announce that there must be no criticism of the president, or
that we are to stand by the president right or wrong, is not only
unpatriotic and servile, but is morally treasonable to the American
public."
-- Theodore Roosevelt
On Jul 23, 2006, at 5:02 PM, Dusty Hale wrote:
> Now that I think of it since things like datasource names don't
> change at all ever, I should probably be using the application scope …
>
>
>
> Dusty
>
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Teddy
> Payne
> Sent: Sunday, July 23, 2006 4:45 PM
> To: discussion@acfug.org
> Subject: Re: [ACFUG Discuss] interesting issue
>
>
>
> Dusty,
> IFrames are buggy to begin with. In the past to overcome this, I
> used a more persistent scope like CLIENT or SESSION scope to
> persist into the IFRAME.
>
> I remember something to the effect that the loading page will get
> the request scope, but the IFrame is created by the browser, so
> that is the client browser creating the request and not the
> application.
>
> Teddy
>
> On 7/23/06, Dusty Hale <[EMAIL PROTECTED]> wrote:
>
> Yes I only have one application.cfm in the webroot and the page
> that is in
> the frame is also in the webroot. Strang one ... ???
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of John Mason
> Sent: Sunday, July 23, 2006 2:28 PM
> To: discussion@acfug.org
> Subject: RE: [ACFUG Discuss] interesting issue
>
> Is the page that is in the frame on the same directory or sub
> directory of
> the application.cfm? Do you have any other application.cfm's floating
> around?
>
> John
> [EMAIL PROTECTED]
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dusty Hale
> Sent: Sunday, July 23, 2006 12:33 PM
> To: discussion@acfug.org
> Subject: [ACFUG Discuss] interesting issue
>
> 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="">> 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
> -------------------------------------------------------------
>
>
>
>
>
> -------------------------------------------------------------
> 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
> -------------------------------------------------------------
>
>
>
>
>
>
> -------------------------------------------------------------
> 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
> -------------------------------------------------------------
>
>
>
>
>
>
> --
> <cf_payne />
> http://cfpayne.wordpress.com/
> -------------------------------------------------------------
> 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 FusionLink
> -------------------------------------------------------------
>
>
> -------------------------------------------------------------
> 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 FusionLink
> -------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?falogin.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
-------------------------------------------------------------
--
<cf_payne />
http://cfpayne.wordpress.com/
-------------------------------------------------------------
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 FusionLink
-------------------------------------------------------------
