Hey everyone: Thanks for the pointers and tips.
I found the problem. It was painfully simple. I needed to specify which table I wanted to pull the fields from. I still have to get the select all out of there and only pull what I need, but here is the working query statement: <cfquery name="q_get_company_n_contacts" datasource="#datasource#" dbtype="odbc"> SELECT * FROM companies LEFT OUTER JOIN contacts ON companies.company_ID = contacts.contact_company_FK WHERE companies.company_ID = <cfqueryparam cfsqltype="cf_sql_integer" value="#company_ID#"> </cfquery> Thanks! Ray At 01:40 PM 12/20/2004, you wrote: > > From my Googling, I have found that Access doesn't like the join > > clause syntax (duh) but I have yet to find the solution. > >I don't work with Access much, but I'm pretty sure it does in fact support >explicit JOIN syntax. I would recommend that you try creating the query >within Access' own query builder, then either running that query using >CFSTOREDPROC or CFQUERY or copying the SQL into your CFQUERY tags. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >phone: 202-797-5496 >fax: 202-797-5444 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188298 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
