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,
topc.topics,
subt.id,
subt.topic_id,
subt.s_topics
FROM topics AS topc
INNER JOIN sub_topics
AS subt
ON topc.id = subt.id
WHERE topc.id = subt.id
----- Original Message -----
From: "Michael Haggerty" <[EMAIL PROTECTED]>
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: 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: "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, 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 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 violation)
> >
> >
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax
> > near '.'.
> >
> >
> >
> > SELECT topc.id,
> > topc.topics,
> > subt.id,
> > subt.topic_id,
> > subt.s_topics
> > FROM topics AS topc
> > INNER JOIN sub_topics
> > AS subt
> > ON topc.id = subt.id
> > WHERE topc.id = subt.id
> >
> >
> >
> > Thanks
> >
> >
> >
> > Doug
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
