Skip to main content
Known Participant
August 27, 2009
Question

Access Database and ColdFusion

  • August 27, 2009
  • 1 reply
  • 832 views

I'm trying to retrieve data from Access DB sitting in coldfusion server but it won't return any data...

Query:

<cfquery datasource="MasterDB" name="AccessQRY">

     Select Employee.Emp_Name, Salary.Emp_ID

     From Employee inner join Salary on (Employee.ID = Salary.ID) AND (Employee.SectionName = Salary.SectionName);

</cfquery>

<cfdump var = "#AccessQRY#">

Is something wrong with my query...

    This topic has been closed for replies.

    1 reply

    Inspiring
    August 27, 2009

    All I could see wrong with your query is the semi colon at the end.  You don't want those in cfqueries.

    What happens when you run the same sql inside Access?

    RosieGpAuthor
    Known Participant
    August 27, 2009

    it just worked... thanks for the semicolon catch though...