When I get this error, it usually ends up that there is a punctuation error in the <cfquery> or as mentioned earlier one of the column names could be a reserved word. Try this: WHERE Topic = 'Americana' add single quotes around Americana as it is a text field with out the Quotes CF may think its trying to match a number.
Hope this helps. Jay Birdsell Deliverables Coordinator /Web Developer Northrop Grumman Information Technology Department of the Treasury Office of the Chief Information Officer HR Connect Program Office 202 - 927 - 6218 "HR Connect : Connecting people, performance, and technology" [EMAIL PROTECTED] -----Original Message----- From: Marcia Gilbert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 17, 2005 6:28 PM To: CF-Newbie Subject: RE: Coldfusion - Access - Dreamweaver HELP! >Do you keep getting the timeouts with the simple test page? I only get the timeout with the simple test page. When I try one of "my" pages, I get the following error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. The error occurred in D:\INETPUB\combsautographs\Americana\Americana.cfm: line 1 1 : <cfquery name="RecAmericana" datasource="CombsAutographsImages"> 2 : SELECT FirstName, LastName, Image, Thumb, Popup, PopWidth, PopHeight, Description, Topic, RetailPrice FROM InventoryImage 3 : WHERE Topic = Americana -------------------------------------------------------------------------- SQL SELECT FirstName, LastName, Image, Thumb, Popup, PopWidth, PopHeight, Description, Topic, RetailPrice FROM InventoryImage WHERE Topic = Americana ORDER BY Last ASC DATASOURCE CombsAutographsImages VENDORERRORCODE -3010 SQLSTATE 07002 My apologies if I've already sent this. I'm posting to several forums at once and my brain is twirling in confusion. And thank-you for your attention! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase Contribute 3 from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=53 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:974 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
