Looks like you have a semi-colon at the end of the tables- isn't that a terminator?
At least you've made M$ Access cry. nice work. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 11 August 2003 17:21 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Probably a stupid question 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] DISCLAIMER: This e-mail is confidential and may also be legally privileged. If you are not the intended recipient, use of the information contained in this e-mail (including disclosure, copying or distribution) is prohibited and may be unlawful. Please inform the sender and delete the message immediately from your system. This e-mail is attributed to the sender and may not necessarily reflect the views of the Patsystems Group and no member of the Patsystems Group accepts any liability for any action taken in reliance on the contents of this e-mail (other than where it has a legal or regulatory obligation to do so) or for the consequences of any computer viruses which may have been transmitted by this e-mail. The Patsystems Group comprises Patsystems plc and its subsidiary group of companies. -- ** 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]
