>
> Probably change
> )="#FORM.MomMonth#"))
> to
> )='#FORM.MomMonth#'))
>
> Jeff Craig
Also, if MomMonth is a date or an integer, no single quotes either.
>
>
> ----- Original Message -----
> From: "Rosa, Issac" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, November 10, 2000 8:43 PM
> Subject: OT:SQL Error in CF but not Access
>
>
> > 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]
>
----------------------------------------------------------------------------
--------------------
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]
------------------------------------------------------------------------------------------------
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]
