We use CFMX 7. When creating a Microsoft SQL Server cf data source name, the following fields are available:
CF Data Source Name Database Server Port Username Password Description Can a developer use cfquery to query a database without a CF Data Source Name by specifying the values for "database", "server", and "port" in the cfquery tag? These are the only attributes that are described in the cfml reference manual for CFMX 7. <cfquery name = "query_name" dataSource = "ds_name" dbtype = "query" username = "username" password = "password" maxRows = "number" blockFactor = "blocksize" timeout = "seconds" cachedAfter = "date" cachedWithin = "timespan" Either of the following: debug = "yes" or "no" or: debug > result = "result_name" </cfquery> It appears that the cfquery attributes that I need have been deprecated according to the cfml7 reference manual. "Deprecated the connectString, dbName, dbServer, provider, providerDSN, and sql attributes, and all values of the dbtype attribute except query. They do not work, and might cause an error, in releases later than ColdFusion 5." >From what I understand, the database, server, and port cannot be passed through a cfquery attribute. Is this correct or am I missing something? -- Thanks, Troy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227368 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
