i did try that, but then was having problems getting the addressing of the query right since it was returning a really "scary" column name...
the syntax for ValueList() is #ValueList(queryname.columnname)#, but didnt work for me when i tried to do it in array notation of #ValueList(queryname['columnname'])# and since the column name is really irregular, it isnt even a valid colum name (or at least in CF) since it has dashes and the like. the solution i have now is just using <CFLOOP> and appending the string manually. definitely not a dramatic problem, but i'll keep toying with it as i have time. thanks for all the answers, peter ----- Original Message ----- From: "Matthew Westcott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 23, 2003 12:50 PM Subject: RE: [cf-xml] CFMX & SQL Server & XML, i'm stuck > On 23 Jul 2003 at 10:54, Askew, Jason wrote: > > > Use columnlist to find the name of the column... it will probably > > change every time. > > > > loop through the records: 1 to query.recordcount. > > > > Reference the column using > > > > query["columnname"][currentrow] and combine all of them into one long > > string. this will then be your full XML document. > > > > The reason sql server breaks them up is there is size limit on the > > column, thus it breaks them into multiple rows. Sorry if my code above > > is sloppy or slightly incorrect, I've done this before but can't find it > > right now =( > > > Could you perhaps use the ValueList function with an empty string as > the > list separator, to combine all the rows into one string without > having to > loop over them for yourself? Just a thought. > > > - Matthew > > > -----------------------+ > cf-xml mailing list > http://torchbox.com/xml/list.cfm > > -----------------------+ cf-xml mailing list http://torchbox.com/xml/list.cfm
