The only thing I can think off from the error below is that you might be using keywords as column names. Try wrapping Image and Description in hard brackets
SELECT FirstName, LastName, [Image], Thumb, Popup, PopWidth, PopHeight, [Description], Topic, RetailPrice FROM InventoryImage Any change? -----Original Message----- From: Marcia Gilbert [mailto:[EMAIL PROTECTED] Sent: 17 May 2005 23:28 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:971 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
