I am running a query in CF against an Access 97 database. The query runs
fine directly in Access, but when I run it from CF, I get:
ODBC Error Code = 07001 (Wrong number of parameters).
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Here's the sql:
SELECT DMDR_Cluster.cluster_name, DMDR_Market.market_name,
DMDR_Drop_Schedule.mailpieces
FROM (DMDR_Drop_Schedule left outer JOIN DMDR_Cluster ON
DMDR_Drop_Schedule.id_cluster = DMDR_Cluster.id_cluster) left outer JOIN
DMDR_Market ON DMDR_Drop_Schedule.id_market = DMDR_Market.id_market
WHERE (((DMDR_Drop_Schedule.month)="#FORM.MomMonth#"))
There are 3 tables - dmdr_cluster (id_cluster, cluster_name)
dmdr_market (id_market, market_name)
dmdr_drop_schedule (id_drop,id_cluster, id_market,
mailpieces)
Any help would be appreiciated.
If you have any questions or concerns, please feel free to call me at
407-514-5021.
Thank you,
> Issac Rosa
>
> IT - National Sales & Marketing
> OLAP Specialist Team Leader
> Ofc: 407-514-5021
> Cell: 407-342-0644
> Fax: 407-514-5988
> [EMAIL PROTECTED]
>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
