>- see footer for list info -< As Tom says, you really want to make more sense of the data if at all possible...
Something like 3 tables: package: ID, other cols products: ID (you are using A,B by the looks of) join: packageID, productID, number of Having a string like that is fairly doomed!! If you can't change the data structure feasibly, you could change the input form at least so that users supply a numeric value for each product- then you could create the string from that which means at least you will have control of its syntax and not be reliant on user text input. HTH d -----Original message----- From: "Paul Swingewood" [EMAIL PROTECTED] Date: Thu, 18 Nov 2004 11:28:49 +0000 To: [EMAIL PROTECTED] Subject: [CF-Dev] listgetat? > >- see footer for list info -< > CAn anyone help me with this one please. > > I have a field in SQL that contains "This package consists of 1 off product > A 2 off product b etc..." > The user types in what is included into a text box on a form. > > I want to be able to display the contents of this field in a list like this > > This package consists of > > 1 off product A > 2 off product B > > etc .... > > How can I code this in coldfusion? > > Regards - Paul > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
