Thanks guys! Once again, you've helped lead me into the solution. Carl, your mockup was spot on.
Here's the code I actually needed to work as it is in myscript. <CFQUERY NAME="all_listings" DATASOURCE="details_at_pages"> SELECT tbl_page_core.title as title, tbl_page_core.created, tbl_page_core.status, tbl_dns.dns_redirect_url as redirect_url, tbl_dns.dns_domain as domain, tbl_dns.dns_subfolder as subfolder FROM tbl_page_core Inner Join details_dns.dbo.tbl_dns ON tbl_page_core.url_id = tbl_dns.dns_id WHERE member_id = <CFQUERYparam value="#myid#"> ORDER BY #COLSORT# #ALPHASORT# ; </CFQUERY> -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon official manual: http://www.openbluedragon.org/manual/ Ready2Run CFML http://www.openbluedragon.org/openbdjam/ mailing list - http://groups.google.com/group/openbd?hl=en
