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.
Ah well. File under "more than one way to skin a domesticated feline"
(apologies to the cat lovers in the audience...)
Pete
On 4/13/05, Justin D. Scott <[EMAIL PROTECTED]> wrote:
> > I'm completely rebuilding an old app, and for a variety
> > of reasons, I would like to "store" the data for a
> > given record from the old database in a field in a new
> > table in a new database. In other words, I'm returning
> > a query that has 1k records and 7 columns of data per
> > record; I would like to grab those 7 columns of data
> > for a single record...
>
> WDDX sounds like it would be the way to go. Normally it would be used to
> convert an entire query at once, but it sounds like you need a package for
> each row. Here's some quick code to do that using Query of Query...
>
> <cfset q = original_query>
> <cfloop query="q">
> <cfquery name="q2" dbtype="query">
> select * from q where id = #q.id#
> </cfquery>
> <cfwddx action="CFML2WDDX" input="#q2#" output="variables.pkg>
> <!--- Use variables.pkg to store in the new database here --->
> </cfloop>
>
> -Justin Scott
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202610
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
