Why not just change the name of the DSN on the server? If that's not feasible, a better approach either way, would to set the DSN name in your application.cfm and use a variable name throughout the cart for the datasource parameter.
In your application.cfm <cfset dsn = "MyDSN"> Then everywhere it says <cfquery datasource="cart"...>, change to <cfquery datasource="#dsn#"...> -- jon mailto:[EMAIL PROTECTED] Saturday, December 14, 2002, 6:14:32 PM, you wrote: w> Or: Is there a way to implement a "CFParam" that will change all references of "Cart" to "MyDSN"? w> Has anyone ever done the "ShoppingCart" tutorial on WebMonkey? If so, do you know how to change the database source from "cart" to "mydsn"? w> http://hotwired.lycos.com/webmonkey/99/49/index4a.html?tw=programming w> Creating a Shopping Cart with ColdFusion w> by Robert Capili w> =================================================== w> copy of files are here: w> http://hotwired.lycos.com/webmonkey/99/49/stuff4a/files.zip w> Thanks everyone, I'll keep the beer cold. w> Steve w> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
