>- see footer for list info -< A small suggestions, do some reading up on creating normalised databases.
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of damian > Sent: 18 November 2004 13:12 > To: Coldfusion Development > Subject: Re: [CF-Dev] listgetat? > > >- 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 > >-< > _______________________________________________ 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 -<
