XMLFormat() !! > -----Original Message----- > From: Asim Manzur [mailto:[EMAIL PROTECTED] > Sent: 27 October 2004 18:58 > To: CF-Talk > Subject: Re: CFXML error > > 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 > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182730 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
