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
