I believe its because as Jochem said earlier CreateODBCDateTime doesn't play nice with OLEDB, the initial connection you were using was going via OLEDB to connect to the DB, where as the connection string below connects via a DNSless ODBC connection where CreateODBCDateTime will work... As its ODBC
HTH -----Original Message----- From: Hirschman, Miriam [mailto:[EMAIL PROTECTED]] Sent: Friday, December 6, 2002 15:08 To: CF-Talk Subject: RE: Using CfQuery tag to establish db connection Thank you very much. It worked I put the Cfset tags in the application page. If you have time, I was just wondering if you would be able to explain to me why my previous code did not work, should I change it even for the queries that it does work for? Thanks again for your time. -----Original Message----- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Friday, December 06, 2002 9:50 AM To: CF-Talk Subject: RE: Using CfQuery tag to establish db connection 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
