Can you be a bit more specific, does it error? Does it not work? <cfset lst=ListAppend(lst,xmlDocHotelData.xmlroot.ImageGallery.xmlChildren[i].xmltext)>
Notice I removed the delimter argument, that is a default anyway so you do not need to pass it. If you do because it is something other than a comma, then this should do the trick. <cfset lst=ListAppend(lst,xmlDocHotelData.xmlroot.ImageGallery.xmlChildren[i].xmltext, '#del#')> HTH but you might need to help us with the error message. On 1/9/08, sam menon <[EMAIL PROTECTED]> wrote: > Hi, > I am trying to construct a "'," delimited string to pass it to cfquery > > this is my code > But its appending only first character, > > <cfset del="',"> > <cfset > lst=ListAppend(lst,#xmlDocHotelData.xmlroot.ImageGallery.xmlChildren[i].xmltext#,#del#)> > </cfloop> > > Can anyone please help me...I am new to coldfusion > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296218 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
