Can't see anything to cause a syntax error but you do have a superfluous WHERE clause as the expression is being handled by the join.
Could you post the CF code that generates the SQL pls. Steve > -----Original Message----- > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > Sent: 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: > 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 > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
