Hi Gerald, yeah that seems the best way to go about it thanks gerald
richard >you can use ColumnList to tease out the column names and use them to >dynamicly created the query. > > <cfquery name="getProj" datasource="#application.DSN#"> > SELECT * > FROM tblProj > > </cfquery> > ><cfset mystring = getProj.ColumnList > > >And do a replace to tack on the table name to the vars so the read something >tblProj.id, tblProj.name, etc. > > <cfquery name="getEmp" datasource="#application.DSN#"> > SELECT * > FROM tblEmp > > </cfquery> > ><cfset mystring2 = getEmp.ColumnList > > >And do a replace to tack on the second table name to the vars > >and then going the two lists like so: ListAppend(mystring ,mystring2 ) > >Then if you know the tables and the ID's you can build the query from the >above. > >hth >G > > >On Tue, May 6, 2008 at 1:22 PM, Richard White <[EMAIL PROTECTED]> wrote: > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
