>- see footer for list info -< Did the reply I gave u on the chat list not work then ?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Ashworth Sent: 11 July 2006 13:35 To: Coldfusion Development Subject: [CF-Dev] query of queries using Verity collection >- see footer for list info -< I would like to perform a query of queries on a Verity Collection whilst performing a join on a table within the database via the verity key is this possible? am struggling to find documentation if it is my query goes along the lines: <cfsearch name="site_search_initial" collection="#request.verity_collection_page_items#" type="simple" criteria="#attributes.site_search_for#"> <cfquery name="site_search" dbtype="query"> select * from site_search_initial, tbl_verity_page_items where site_search_initial.key like tbl_verity_page_items.vpi_id and tbl_verity_page_items.vpi_member like #session.logged_in#; </cfquery> _______________________________________________ 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 -<
