converting cftree path to variables

ok folks possible convert path cftree list?
or extract elements of path may converted
to variables used in query?

i'm creating holiday review site , hotels in cftree categorised board type
and when info of hotel reviewed chosen , passed page info in path tree.

path:
ibiza\san antonio\all inclusive\tanit

is possible take above path , use variables used in query retrieve
information on particular hotel.


to give more of idea here part of query in path used:

where c.country_id = r.country_id
and r.resort_id = a.resort_id
and at.accom_type_id = a.accom_type_id
and a.accom_id = rv.accom_id
and u.user_id = rv.user_id
and c.country_name = 'ibiza' , r.resort_name = 'san antonio'
and at.accom_type = 'all inclusive' , a.accom_name = 'tanit'
order holdate desc;


as can see used filter hotel chosen in cftree.
since path contains different info depending on country, board type, , hotel required.

the path needs converted variables used in filter.

here examples of different paths:
cuba\cayo guillermo\all inclusive\sol guillermo
mexico\can cun\all inclusive\palace
majorca\alcudia\self catring\apartments sol
ibiza\escana\bed & breakfast\aparthotel la cala

More discussions in ColdFusion

adobe