Justin, that was it. I wish I had another set of eyeballs at the office to bounce this sort of thing off of...
I tried the QoQ method first, and it worked, but took about 50 minutes to run. The method I used took less than half the time (keep in mind that I'm developing on my workstation at home, the database is at work on a DSL connection and I'm VPN'ed into it, so it's not an optimally performing connection) Thanks! Pete On 4/13/05, Justin D. Scott <[EMAIL PROTECTED]> wrote: > > Thanks, Justin, that did it. I was trying this route: > > > > <cfset qryRowData = queryNew(getVendors.columnlist)> > > <cfloop list="#getVendors.columnlist#" > > index="i" delimiters=","> > > <cfset > > querySetCell(qryRowData,i,getVendors[i][getVendors.currentRow])> > > </cfloop> > > > > but was getting a "The row number, (0) is out of bound." error. > > Just as an FYI, you were getting that error because you didn't add a row to > your new query before trying to set the data cells. Right before that loop > you would need... > > <cfset queryAddRow(qryRowData)> > > ....to add a row to the query before putting data in it. > > > -Justin Scott > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202716 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
