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 > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
