That is totally weird. Right after I got this error I refreshed and it
worked.
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect
syntax near '.'.
The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (1:1) to (1:65) in the
template file C:\CARNIVOREPC\_FORUM\_QRY\QRY_GET_TOPICS.CFM.
Date/Time: 12/11/01 09:08:45
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Remote Address: 66.27.3.82
<CFQUERY DATASOURCE="#request.site.forum_dsn#" NAME="get_topics">
SELECT topc.id,
topc.topics,
sub.id,
sub.topic_id,
sub.s_topics
FROM topics AS topc
INNER JOIN sub_topics AS sub ON topc.id = sub.id
WHERE topc.id = sub.id
</CFQUERY>
Doug
----- Original Message -----
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 is the actual cfquery block
> containing this query? don't modify it at all, just show the actual cfm
> query...
>
> -----Original Message-----
> From: Douglas Brown [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
> '.'.
>
>
>
> 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
