- 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 -<
