- see footer for list info -<
Sorry Snake, yes it did work and many thanks, I just wanted to see what other peoples thoughts on this were and to post it on the correct forum, just for someone else's future reference if needed
On 7/11/06, Snake <[EMAIL PROTECTED]> wrote:
>- 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 -<
_______________________________________________ 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 -<
