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
-------------------------------------------------------------
