Jason T. Slack wrote: > > Now it tells me that my datasource is undefined: Variable MYDSN is > undefined. > >> >> <cfquery name="ckCreds" datasource="#MyDSN#">
If your DNS is named "MyDSN", then remove the # signs from around the name of the DSN.. it's not a variable. In my code, I often do something in the application.cfm like this: <cfset application.primarydb = "MyDSN"> Then in my queries.... <cfquery name="ckCreds" datasource="#application.primarydb#"> That way, if you change your datasource name, you only have to change it in your application.cfm Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259989 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4