I have a query that gets a column from my database of chalets. The
column shows a list of the near by resorts, seperated by commas.
So for a chalet it could have:
'Val d'Isere, Meribel, Courcheval' in the field linkedResorts
I want to seperate these in order to get the resorts individual id's from
the resorts table.
I have used cfloop like this:
<cfquery name="Recordset1" datasource="dsn">
WHERE id = '10'
<cfloop delimiters="," list="#Recordset1.linkedResorts#" index="List">
<cfquery name="hump" datasource="dsn">
SELECT id, resort FROM resorts WHERE resort = <cfoutput>'#List#'</