I think that the ColdFusion Administrator DataSource control panel has been
elevated to a degree where you can enter most of these values directly into
the datasource setup screen.
Unless you are in a hosted environment you should have more control over
these settings.
If not at least try to ensure that your host can set default
username/password values to avoid hardcoding it within your templates. If
they cannot or will not do that then use the request scope in the
Application.com file, eg:
<cfsetting enablecfoutputonly="yes">
<cfif not isdefined("Request.DataSourceName")>
<cfparam name="Request.DataSourceName" default="mydatasource">
<cfparam name="Request.DataSourceUser"
default="requiredloginnamefordboperation">
<cfparam name="Request.DataSourcePassword"
default="passwordforrequiredaction">
</cfif>
<cfsetting enablecfoutputonly="no">
HTH.
Peter Tilbrook
ColdFusion Applications Developer
ColdGen Internet Solutions
4/73 Tharwa Road
Queanbeyan, NSW, 2620
AUSTRALIA
Telephone: +61-2-6284-2727
Mobile: +61-0439-401-823
E-mail: [EMAIL PROTECTED]
World Wide Web: http:/www.coldgen.com/
==
Analust - word meaning a Analyst (like myself) seeking work as an
analyst/programmer.
-----Original Message-----
From: Gary Hotko [mailto:[EMAIL PROTECTED]
Sent: Friday, 5 September 2003 4:13 PM
To: CF-Talk
Subject: Re: cfquery??
Does anyone know when Macromedia posted the depreciation (a date would
help?)
Tony Weeg wrote:
>i can answer this one..
>
><cfquery name="" datasource="">
></cfquery>
>
>is all i have used since day 1.
>
>now, you may need to use username/password for some odd
>reason...but thats it :)!
>
>tony
>
>-----Original Message-----
>From: Gary Hotko [mailto:[EMAIL PROTECTED]
>Sent: Thursday, September 04, 2003 3:59 PM
>To: CF-Talk
>Subject: Re: cfquery??
>
>
>So when i am coding what should I use?
>
>Or is it going to be that all you need to do is name and datasource?
>
>Dave Watts wrote:
>
>
>
>>>So, if cfquery is a deprecated tag, what should we be using
>>>in its place??
>>>
>>>Anyone heard anything about this?
>>>
>>>http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p18.htm
>>>
>>>
>>>
>>>
>>I think you're misreading that. To me, it looks like they're saying
>>
>>
>that the
>
>
>>CONNECTSTRING, DBNAME, DBSERVER, PROVIDER, PROVIDERDSN, and SQL
>>
>>
>attributes
>
>
>>are deprecated, along with most values for DBTYPE.
>>
>>Dave Watts, CTO, Fig Leaf Software
>>http://www.figleaf.com/
>>voice: (202) 797-5496
>>fax: (202) 797-5444
>>
>>
>>
>>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
