How about if you connect something like
<CFSET sConnectionString = "Driver={Microsoft Access Driver (*.mdb)};">
<CFSET sConnectionString = sConnectionString & "Dbq=c:\somepath\mydb.mdb;">
<CFSET sConnectionString = sConnectionString & "Uid=admin;Pwd=">
<CFQUERY NAME="qryFoo" DBTYPE="dynamic" CONNECTSTRING="#sConnectionString#">
...
</CFQUERY>
HTH
-----Original Message-----
From: Hirschman, Miriam [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 6, 2002 14:32
To: CF-Talk
Subject: RE: Using CfQuery tag to establish db connection
No, I have not, but I am not sure how to do this.
This is my query, it uses variables, but I pasted the real values for you.
SELECT CommentID,Comment, [CommentID] & [Comma] & [niin] & [Comma] &
[myDate] & [Comma] & [Author] & [Comma] & [Nomenclature]AS Holder FROM
qryComment_Nomenclature Where niin= '000750603' and (myDate <= {ts
'2002-12-06 00:00:00'}) ORDER BY myDate DESC
-----Original Message-----
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 06, 2002 9:32 AM
To: CF-Talk
Subject: RE: Using CfQuery tag to establish db connection
What does the query look like?
Have you tried connecting with a connection string instead...
-----Original Message-----
From: Hirschman, Miriam [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 6, 2002 14:21
To: CF-Talk
Subject: Using CfQuery tag to establish db connection
I posted this once, but did not receive an answer. I would appreciate any
help. I am trying to do a cfquery without setting up a DSN on the CF Admin.
I am using CF 5. I pasted the code that I am using below. It works fine in
most instances however, when using a query that uses the CreateODBCDateTime
I get an error: Malformed GUID. in query expression. I am using Access 97
and 2000. This query works fine when I set up the DSN in the Admin.
This is my code:
<CFQUERY NAME="qryGetUserName" DATASOURCE="#strConn#"
providerdsn="#strConn#"
dbtype="OLEDB"
provider="Microsoft.Jet.OLEDB.4.0"
username="Admin"
password="">
Thank you
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
