First of all ... How are you trying to insert/update using the below data? I mean the code?
You can do this.. <cfset x="SUS","DECORA","1903141001","Garden Elements, a source book of decorative ideas to transform the garden","CLIFTON JOAN",45.00,0,"HB","2000"> insert into tablename(#ListGetAt(x, 1 ,""")#).... You can also change the delimiters like <cfset newList=ListChangeDelims(x,":",""")> I can think of about 4 or 5 ways of manipulating your LIST.. but the best way depends on what you are trying to do. Your end use code is not clear Joe ----- Original Message ----- From: "Seamus Campbell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 2:28 AM Subject: list delimiter problem > Hi > > I have a list - the format of which I cannot change. One line as an example > below > > "SUS","DECORA","1903141001","Garden Elements, a source book of decorative > ideas to transform the garden","CLIFTON JOAN",45.00,0,"HB","2000", > > Sometimes there is a comma in the title as above so when I am > inserting/updating the contents into a database > > Garden Elements is taken as one field > and > a source book of decorative ideas to transform the garden as another > > I am trying to change the delimiters but I can't work out how to not to > change the comma, for instance, inside the title field > "Garden Elements, a source book of decorative ideas to transform the garden" > > Does anyone have any clues please > > Seamus > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
