i replace the sigle quote to the double quote and the error gone.
Not sure that why. it suppose to be the same thing isn't it??
Thanks anyway.
>> <cfquery name="getDealers" datasource="#DSN#"> select id,
>
>Perhaps there's an XML metacharacter in your getDealers.name variable?
>
>On an unrelated note, I suspect you can simplify this quite a bit by using a
>single query to get the ad count with the other dealer information. This
>obviously untested query might work for you:
>
>SELECT d.id,
> d.name,
> COUNT(da.dealer)
>FROM dealers d,
> DealerAds da
>INNER JOIN d.id = da.dealer
><cfif IsDefined("Form.month1") and Form.month1 neq "A">
>WHERE da.created BETWEEN #startdate# AND #enddate#
></cfif>
>GROUP BY d.id
>ORDER BY d.name
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>phone: 202-797-5496
>fax: 202-797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182721
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
