On 6/14/07, Robert Rawlins - Think Blue <[EMAIL PROTECTED]> wrote: > > Hello Guys, > > however, how do I have it so the username and password must > be supplied in my cfquery or stored proc tags? > > I'm not sure if this makes any difference, but the SQL Server and the CF > are > running on the same box and its SQL Server 2005 Standard and ColdFusion > MX7 > Standard.
If you are on a dedicated server "You manage all websites" Saving the username and password inside the datasource record is the most secure method. It's better then saving it in the query statements on your page. You could also create two datasources, one for administrative functions where you need insert update select, then another that is only select and switch between the two in your applications. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
