I have the following query - Not Ideal I know ... Lots of innerjoins, etc..
<cfquery name="projectCharter" datasource=""> SELECT tbl_Project.projectId, tbl_projectCharter_approach.approachContent, tbl_projectCharter_approval.approvalContent, tbl_projectCharter_assumptions.assumptionsContent, tbl_projectCharter_background.background, tbl_projectCharter_benefits.benefitsContent, tbl_projectCharter_consider.considerContent, tbl_projectCharter_risks.risksContent, tbl_projectCharter_resources.resourcesContent, tbl_projectCharter_issues.issuesContent, tbl_projectCharter_highlevel.highleveContent, tbl_projectCharter_dependencies.dependenciesContent, tbl_projectCharter_deliverables.deliverablesContent, tbl_projectCharter_constraints.constraintsContent, tbl_projectCharter_scope.scopeContent, tbl_projectCharter_stakeholders.stakeholderContent, tbl_projectCharterObjective.content; FROM (((((((((((((((tbl_Project INNER JOIN tbl_projectCharter_approach ON tbl_Project.projectId = tbl_projectCharter_approach.approachId) INNER JOIN tbl_projectCharter_approval ON tbl_Project.projectId = tbl_projectCharter_approval.approvalId) INNER JOIN tbl_projectCharter_assumptions ON tbl_Project.projectId = tbl_projectCharter_assumptions.assumptionsId) INNER JOIN tbl_projectCharter_background ON tbl_Project.projectId = tbl_projectCharter_background.projectCharterId) INNER JOIN tbl_projectCharter_benefits ON tbl_Project.projectId = tbl_projectCharter_benefits.benefitsId) INNER JOIN tbl_projectCharter_consider ON tbl_Project.projectId = tbl_projectCharter_consider.considerId) INNER JOIN tbl_projectCharter_constraints ON tbl_Project.projectId = tbl_projectCharter_constraints.constraintsId) INNER JOIN tbl_projectCharter_deliverables ON tbl_Project.projectId = tbl_projectCharter_deliverables.deliverablesId) INNER JOIN tbl_projectCharter_dependencies ON tbl_Project.projectId = tbl_projectCharter_dependencies.dependenciesId) INNER JOIN tbl_projectCharter_highlevel ON tbl_Project.projectId = tbl_projectCharter_highlevel.highlevelId) INNER JOIN tbl_projectCharter_issues ON tbl_Project.projectId = tbl_projectCharter_issues.issuesId) INNER JOIN tbl_projectCharter_resources ON tbl_Project.projectId = tbl_projectCharter_resources.resourcesId) INNER JOIN tbl_projectCharter_risks ON tbl_Project.projectId = tbl_projectCharter_risks.risksId) INNER JOIN tbl_projectCharter_scope ON tbl_Project.projectId = tbl_projectCharter_scope.scopeId) INNER JOIN tbl_projectCharter_stakeholders ON tbl_Project.projectId = tbl_projectCharter_stakeholders.stakeholderId) INNER JOIN tbl_projectCharterObjective ON tbl_Project.projectId = tbl_projectCharterObjective.objectiveId WHERE projectId = #URL.recordId# </cfquery> Bit of a silly query to start with right, Okay Okay I know... problem is, the WHERE statement at the end causes it to throw out an error Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Characters found after end of SQL statement. I'm assuming that the WHERE statement is the problem coz when I remove it the page renders fine (eventually) Okay, what do I need to do to make this query run from a url Id? Without the exception? And please don't shout at me for the ridiculous query.. I'm only a designer.. ;) Ash -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
