>- see footer for list info -< Paul are you saying your entries in the database are in this format??? if so, it might be useful to have another table and lookup between the 2. you'll end up with something like the following - remembering this is "psuedo" - and does contain reserved words for SQL...
tbl 1 id package name [... n fields] tbl 2 id product [... n fields] tbl_lookup tbl1_id tbl2_id where you link using tbl.id = tbl_lookup.tbl1_id and tb2.id = tbl_lookup.tbl2_id Hope that makes sense, and I haven't confused matters... your request for listgetat() might be a difficult one as you don't seem to have a good delimter for the data. ----- Original Message ----- From: Paul Swingewood To: [EMAIL PROTECTED] Sent: Thursday, November 18, 2004 11:28 AM 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 -<
