subt.id
WHERE
topc.id = subt.id
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?
-
ember 2001 8:12 PM
To: CF-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:[
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
ROTECTED]>
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
t: 11 December 2001 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:
>
[mailto:[EMAIL 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
dunno... 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
>
To: "CF-Talk" <[EMAIL PROTECTED]>
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: Tuesda
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
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
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
ROTECTED]>
>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. This is a SQL 2K
> > database
> >
> > ODBC Error Code = 37000 (Syntax error or access viol
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
I keep getting this error when I run the query. This is a SQL 2K
database
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax
near '.'.
SELECT topc.id,
topc.topics,
14 matches
Mail list logo