Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Application.cfm DSN 1
- Thread starter rmz8
- Start date
-
1
- #2
On the Application.cfm page set a variable to represent your DSN name.
<CFSET dsn = "MyDataSource">
<CFSET pwd = "password">
<CFSET userid = "username">
****************************************
Reference these global variables in your queries as:
<CFQUERY
NAME="MyQuery"
DATASOURCE="#dsn#"
USERNAME="#userid#"
PASSWORD="#pwd#">
{(xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx)}
</CFQUERY>
I don't know if this is the most elegant way to do it or not, but it works.
<CFSET dsn = "MyDataSource">
<CFSET pwd = "password">
<CFSET userid = "username">
****************************************
Reference these global variables in your queries as:
<CFQUERY
NAME="MyQuery"
DATASOURCE="#dsn#"
USERNAME="#userid#"
PASSWORD="#pwd#">
{(xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx)}
</CFQUERY>
I don't know if this is the most elegant way to do it or not, but it works.
- Status
Similar threads
