I was hoping that was not really the error... I don't see how this could be causing the error, but it seems like you are joining on the wrong id field. Did you really mean to join on the id fields of each table, or were you meaning to join on topics.id to to sub_topics.topic_id?
I 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 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists