i have had that and if i remember right is was lack of having single quotes dont forget cfqueryparam!!!
<cfquery datasource="#mydbname#" name="GetUsers"> SELECT * FROM contacts,ImageList WHERE contacts.ContactID = <cfqueryparam value="#ImageList.ContactID#" cfsqltype="cf_sql_integer"> </cfquery> ---------- Original Message ---------------------------------- From: "Phillip Perry" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 25 Oct 2004 15:37:54 -0400 >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=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182551 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
