That is why I said cfinsert enhancement not cfquery enhancement...
jon
----- Original Message -----
From: "Hayes, David" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2001 5:57 PM
Subject: RE: Insert query? - nevermind
> 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
