Might give that a try,
Bill K
-Original Message-
From: Michael Haggerty [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 11:28 AM
To: CF-Talk
Subject: RE: Does anyone see a problem with this query?
What is the error you are getting?
-Original Message-
From: Douglas Brown
I don't know if I'm alone in this, but at first, second, and third glance
your query syntax seems fine.
Is there anything else to this query?
-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: 11 December 2001 00:42
To: CF-Talk
Subject: Does anyone see a problem
Absolutely nothing else.
Doug
- Original Message -
From: Mike Connolly [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, December 11, 2001 2:12 AM
Subject: RE: Does anyone see a problem with this query?
I don't know if I'm alone in this, but at first, second
What is the error you are getting?
-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 11:39 AM
To: CF-Talk
Subject: Re: Does anyone see a problem with this query?
Absolutely nothing else.
Doug
- Original Message -
From
]
Sent: Tuesday, December 11, 2001 8:27 AM
Subject: RE: Does anyone see a problem with this query?
What is the error you are getting?
-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 11:39 AM
To: CF-Talk
Subject: Re: Does anyone see
PROTECTED]]
Sent: Tuesday, December 11, 2001 10:49 AM
To: CF-Talk
Subject: Re: Does anyone see a problem with this query?
Here is the original post
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near
'.'.
SELECT
... this is a wierd one. Maybe the problem has to do with the
permissions on CF?
Mike
-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 11:49 AM
To: CF-Talk
Subject: Re: Does anyone see a problem with this query?
Here is the original post
ODBC
16:49
To: CF-Talk
Subject: Re: Does anyone see a problem with this query?
Here is the original post
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2:
Incorrect syntax near
'.'.
SELECT topc.id
-
From: Dunwiddie, Bruce [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, December 11, 2001 8:51 AM
Subject: RE: Does anyone see a problem with this query?
I have a feeling that this is not the actual query that's running, you're
just assuming it is. I may be wrong, but what
yeah, I see a problem alright!
From: Dunwiddie, Bruce [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: Does anyone see a problem with this query?
Date: Tue, 11 Dec 2001 10:51:50 -0600
I have a feeling that this is not the actual query that's running
-Talk
Subject: RE: Does anyone see a problem with this query?
I don't know if I'm alone in this, but at first, second, and third glance
your query syntax seems fine.
Is there anything else to this query?
-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: 11 December
P.S This same query works great in query analyzer
Doug
- Original Message -
From: Douglas Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, December 10, 2001 4:41 PM
Subject: Does anyone see a problem with this query?
I keep getting this error when I run the query.
leave out the 'AS' in the from line
At 04:47 PM 12/10/2001 -0800, you wrote:
P.S This same query works great in query analyzer
Doug
- Original Message -
From: Douglas Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, December 10, 2001 4:41 PM
Subject: Does anyone see
13 matches
Mail list logo