yeah, I see a problem alright!
>From: "Dunwiddie, Bruce" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Does anyone see a problem with this query? >Date: Tue, 11 Dec 2001 10:51:50 -0600 > >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
