It works a treat - thanks stephen, and I will post a new mail next time. Sam
-----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 07 April 2004 13:21 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CF MS Access conflict? Sam Westlake wrote: > I am trying to execute the following query: > > <cfquery name="subMenuItems" datasource="propertyDSN"> SELECT > t_SectionXFA.subxfaID, t_SubXFA.subxfaKey, t_SubXFA.subxfaValue, > t_SectionXFA.xfaID, t_XFA.xfaKey FROM t_XFA INNER JOIN (t_SubXFA INNER > JOIN t_SectionXFA ON t_SubXFA.subxfaID = t_SectionXFA.subxfaID) ON > t_XFA.xfaID = t_SectionXFA.xfaID > where t_XFA.xfaKey = "planning" > </cfquery> > > but I get an Error Executing Database Query exception thrown. > > If I omit the [where t_XFA.xfaKey = "planning"] code then CFMX is > happy. If I leave the line in then it throws the exception. > > In t he Access query tool, the SQL generates a record set without > complaints with or without the where statement included. > > Is this a CF bug and what can I do about it? Is this an appropriate > time to use Query of Queries? > The issue that you have is that you need to use single quotes and not double quotes in your where clause eg. xfaKey = 'planning' You don't need to use QofQ for this. Regards Stephen PS. When posting a new topic please post a new email/forum post rather than replying to an existing thread. Thanks. -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
