Solved my own question (used access to generate the SQL and then tidied it
up :D)
<cfquery name="getMenuItems" datasource="cjcormack">
SELECT MENU_ITEMS.*
FROM (LEVELS AS LEVELS_1 INNER JOIN
(LEVELS INNER JOIN MENU_ITEMS
ON LEVELS.LEVEL_ID = MENU_ITEMS.MENU_ITEM_LEVEL_MIN)
ON LEVELS_1.LEVEL_ID = MENU_ITEMS.MENU_ITEM_LEVEL_MAX)
WHERE LEVELS.LEVEL_VALUE<=#user_level_value#
AND LEVELS_1.LEVEL_VALUE>=#user_level_value#
AND MENU_ITEMS.MENU_ID=#getMenus.MENU_ID#
ORDER BY MENU_ITEMS.MENU_ITEM_POSITION
</cfquery>
Chris Cormack
British Telecommunications plc
Registered office: 81 Newgate Street London EC1A 7AJ
Registered in England no. 1800000
This electronic message contains information from British Telecommunications
plc which may be privileged or confidential. The information is intended to
be for the use of the individual(s) or entity named above. If you are not
the intended recipient be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. If you have
received this electronic message in error, please notify us by telephone or
email (to the numbers or address above) immediately.
Activity and use of the British Telecommunications plc E-mail system is
monitored to secure its effective operation and for other lawful business
purposes. Communications using this system will also be monitored and may be
recorded to secure effective operation and for other lawful business
purposes.
Any views expressed in this email do not reflect those of BT and any of
partners and assosiates. Responsiblity for the opinions expressed are those
of the sender only
>
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
