Dont know if this is common but, using MS Access, the ContactID foreign key is spelled differently when looked at in "design view" as opposed to its regular display. When I switched the spelling it worked out.
Thanks for the help Phil -----Original Message----- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 3:38 PM To: CF-Talk 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. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182538 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