> 1. Just curious, is it possible to do a query across two
> different datasources? I have a table in one datasource and
> I would like to do some kind of join query on another table
> that would make things simple except that the other table is
> in another datasource. Is it possible to do the query regardless
> of the fact that the tables are in different datasources?
No, you can't generally do this from within CF. You do have some options,
though. Your database may allow referencing other databases from within your
query; SQL Server 7, for example, lets you do some things like this. Also,
you can simply query each datasource, then merge the query results within
CF. This will require a little CF code, but I believe there are custom tags
available (one called CF_MERGEQUERY comes to mind) which will do this.
> 2. Is it possible to do a query on a query result set? I have
> the results from a CFQUERY but I was wondering if one could then
> do a query using the query results as if it was a table itself?
No, you can't use SQL to filter recordsets after you've retrieved them.
However, again, you can build something analogous to this using CFML to
filter your recordset.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
