Hi List, Need some help...
I'm experimenting with XML query statements in SQL 2000 and have run into a problem that I can't figure out under CF 4.51. Here's the query: select top 2 name, city, state, zip from [restfile] Restaurant where city='rye' for xml auto,elements When I run the query in Query Analyzer, I see my output lumped under a column name "XML_F52E2B61-18A1-11d1-B105-00805F49916B". Output in QA is: <Restaurant><name>Belluscio's Restaurant</name><city>Rye</city><state>NY</state><zip>10580</zip></Restaurant><Restaurant><name>Cafe Livorno</name><city>Rye </city><state>NY</state><zip>10580</zip></Restaurant> I get the same column name when I use the custom tag CF_DumpQuery. The problem is that when I try to output this query , I get an error. "Just in time compilation error Invalid parser construct found on line 11 at position 15. ColdFusion was looking at the following text:- Invalid expression format. The usual cause is an error in the expression structure. " Anyone have any idea how I can make this work? Sincerely yours, Jim Gurfein President, CEO RestaurantRow.com, Inc. http://www.restaurantrow.com 914.921.3200 ext 101 914.921.9190 fax ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4