This is analogous to the periodic "can I use javascript to set my cf
variables?" post - your CF object and your database are in different
"places". The CF Query Object isn't going to be recognized by your database
application.
The tables don't have to be the same to use an INSERT...SELECT statement;
you specify which fields you want to use, and transform the data as needed
in the select statement.
You'll have to create multiple insert statements, whether you do it in CF or
do it in a stored procedure; if you have a large number of records to
insert, you could output your Query Object to a formatted text file and
import directly into your db using a manual or automated process.
-----Original Message-----
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 3:35 PM
To: CF-Talk
Subject: Re: Insert query? - nevermind
I just remembered I asked this question some time ago, and the answer was
no. I would really love to be able do this though...
cfinsert enhancement perhaps? Any technical reasons why this could not be
done?
jon
----- Original Message -----
From: "Jon Hall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2001 4:30 PM
Subject: Insert query?
> I know it's possible to Insert a Select statement if the tables are
exactly
> the same, however is it possible to insert a CF queryset? Something
like...
> <cfquery>
> INSERT INTO Table(Columns,...)
> #GeneratedQuery#
> </cfquery>
>
> jon
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
