Could it be that you just need to XMLParse() your output? Dina
On 6/2/06, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > > What errors are you getting? And is #tablename# defined? > > This should work.!! > > > > -----Original Message----- > From: Joe Graves [mailto:[EMAIL PROTECTED] > Sent: 02 June 2006 07:11 > To: SQL > Subject: Sql XML > > I have been having problems making the code below work. Any sugestions? > > <CFQUERY NAME="GetData" DATASOURCE="XYZ" MAXROWS=3> > SELECT * > FROM #TableName# > FOR XML AUTO > </CFQUERY> > > <CFOUTPUT>#GetData#</CFOUTPUT> > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2473 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
