LOL...thanks for your efforts! Are u subscribed to the cf-community list? If not, and you're prone to getting distracted easily, I would not recommend it. I lose hours sometimes, then end up having to make the lost time up later in the day. People with ADD (I suspect I have it) should steer clear of lists like these!
If you're ever in New Hampshire, I will buy you a beer for your efforts. :) Don't know why anyone would be here right now, though. It is like a blizzard outside my window! Thanks again! Ray At 01:47 PM 12/20/2004, you wrote: >Hah... > >I was just about to post that you need a where clause. I've been messing >with it for the last half hour! > >I need to ban list reading during work hours. I want my 1/2 hour back! > >-e > >-----Original Message----- >From: Ray Champagne [mailto:[EMAIL PROTECTED] >Sent: Monday, December 20, 2004 1:38 PM >To: CF-Talk >Subject: RE: database query > >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:188303 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
