Hi Kevin, You must be doubling up a call to QueryAddRow(). Go do a search on github.com for a piece of code called QuerySim by Hal Helms. It'll help you create queries you need, and it's very easy to use.
- Rex On 3/23/2011 5:01 AM, Steven Durette wrote: > First, let me say that anything that can be done in the database should be. > But, if you must do it this way, why don't you have the db return the extra > columns as nulls then set the cell values. That way you don't have the extra > query object being built. > > Steve > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm