Forget that page and create a test page with a simplified query in it.
test.cfm:
<cfquery name="RecAmericana" datasource="CombsAutographsImages">
SELECT *
FROM InventoryImage
</cfquery>
<cfdump var="#RecAmericana#">
Does this work?
Ade
-----Original Message-----
From: Marcia Gilbert [mailto:[EMAIL PROTECTED]
Sent: 17 May 2005 19:32
To: CF-Newbie
Subject: Re: Coldfusion - Access - Dreamweaver HELP!
> In some other databases this might indicate case sensitivity in the
> table name ie. you have "InventoryImage" in your code and
> "inventoryimage" in the database, so your code can't find the table in
> the database.
Oooh, we were so close! I checked my Access database and yes, there was a
naming problem. But I fixed that and reloaded it up the CT site. Alas, that
wasn't it, but I did get a different error, which I've put below:
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
Thank you so much for your help so far. Why did I ever stray from design
into web design?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:965
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
