Yep, Lookup the query functions in the docs (ie. QueryNew(), QueryAddRow(), QuerySetCell(), QueryAddColumn().
http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00000367.htm HTH Dominic 2008/7/4 Jenny Gavin-Wear <[EMAIL PROTECTED]>: > I recall seeing somewhere that it is possible to build a query on the fly? > > The scenario is, I will have some data values which could be contained in > form generated structs. I will need to search the struct for the column > name existing, and when it does, use those values for the generated query. > > Hope this makes sense, > > Jenny > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308590 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4