<snip>
I was going to add this:
<CFSET vardatasource = "mydatasource">
<CFSET varusername = "myusername">
<CFSET varpassword = "mypassword">
And change all the references (yes I do realize I have to go through all 150
files to do this) from:
<CFQUERY DATASOURCE = "mydatasource" USERNAME = "myusername" etc... >
to this:
<CFQUERY DATASOURCE = #vardatasource# USERNAME = #varusername# etc... >
But can I add this to just one page (the application.cfm page?) so that
these variables can be changed in only one page to affect all of the pages?
So if I change mydatasource to hisdatasource I only have to goto this one
page rather than all 150 and changing the variables at the top of the page
(unlike last time where I changed the name in all of the references).
Is there any other way than passing by using url parameters?
Rolando
</snip>
Rolando,
This is done in the application.cfm page. You would have in your
application.cfm:
<CFSET Application.Datasource = "mydatasource">
<CFSET Application.Username = "myusername">
<CFSET Application.Password = "mypassword">
Then, in your queries, you would say something like:
<CFQUERY NAME="MyQuery" Datasource = "#Application.Datasource#" Username =
"#Application.Username#" Password = "#Application.Password#">
Blah Blah Blah
</CFQUERY>
When you do it in this manner, there will be no URL parameters for these variables.
Just make sure in the application.cfm page, you enable sessionmanagement and
clientmanagement, and name your application! Hope this helps!
Chris Ivey
MTS Systems Engineer
GTE Data Services: Temple Terrace, Florida
TSS Distributed - WAN Tools Group
Office: (813) 978-4844
Pager: (813) 303-1177
AIM: IveyAtGTEDS
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
