Here's what I'd do - go into access and use the query builder to build the query. You may have to use the inner join syntax instead of the where syntax. I don't use access, but it's something like:
SELECT * FROM contacts INNER JOIN imagelist ON contacts.contactid = Imagelist.contactid ----- Original Message ----- From: "Phillip Perry" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 25, 2004 2:37 PM Subject: RE: Getting 4 results where there should be only 2 > Yes I adjusted it for my purpose and I even spelled out every single > fieldname in the select clause, but doing that just gave me the same error > except now its missing 3 parameters instead of 2. Here is the code as it > was > adjusted per your code example.. > > <cfquery datasource="#mydbname#" name="GetUsers"> > SELECT * > FROM contacts,ImageList > WHERE contacts.ContactID = ImageList.ContactID > </cfquery> > > Which gives the error.... > > Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft > Access Driver] Too few parameters. Expected 2. > > There you have it. Nothing is misspelled. and ContactID is in both tables > spelled the same way. > -----Original Message----- > From: Deanna Schneider [mailto:[EMAIL PROTECTED] > Sent: Monday, October 25, 2004 3:33 PM > To: CF-Talk > Subject: Re: Getting 4 results where there should be only 2 > > > Um, that was totally pseudocode. You did modify it for your table > structure, > right? It might help to actually post the table structure. > > ----- Original Message ----- > From: "Phillip Perry" >>I tried this and I'm getting an error saying too few parameters expecting >>2. >> Dont know what that means though. >> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182546 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