Apologies if any of this has been said or turns out to be useless. I'm a
little late jumping into the thread. Incidentally... I use CrystalTech, and
I create my own CF Admin datasources via their customized control center.
What I would do, despite that CT's control center will allow you to test and
verify your datasources, is this:
Make a new table in the same .mdb -- make only one column called Marcia with
one row that has Gilbert in it. Do a real simple query just as a control
measure.
<cfquery name="myQuery" datasource="CombsAutographsImages"
select * from myTable where Marcia = 'Gilbert'
</cfquery>
If you get no errors and can output a recordcount, then go back to your
InventoryImage table and your original query. Remove everything from the
query except for the first column:
<cfquery name="RecAmericana" datasource="CombsAutographsImages">
select FirstName from InventoryImage where Topic = 'Americana'
</cfquery>
(Americana needs ' ' around it... or whatever variable you may have there in
your code. where Topic = '#myVariable#')
If that works, add your second column back in:
<cfquery name="RecAmericana" datasource="CombsAutographsImages">
select FirstName, LastName from InventoryImage where Topic = 'Americana'
</cfquery>
Test it again. Continue adding columns back one at a time until you get the
error. You will then know which column is the offending column. Once you
fix it, continue adding columns back in one at a time in case you had more
than one offending column.
MS Access can be incredibly quirky.
-----Original Message-----
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 17, 2005 6:45 PM
To: CF-Newbie
Subject: RE: Coldfusion - Access - Dreamweaver HELP!
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!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Now there’s a better way to fax. eFax makes it possible to use your existing
email account to send and receive faxes. Try eFax free.
http://www.houseoffusion.com/banners/view.cfm?bannerid=63
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:972
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
