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]
