runtime what tables were involved... so i gave him a cf routine similar to
yours but generic... mine has a small problem with the insert... but I'm
sure he can figure it out...
I was just curious as to how you would use a "select into" statement in a
<cfquery> across databases with cf...
later,
Gonz
At 11:18 AM 4/22/04, you wrote:
>or you can certainly update, delete or do whatever, but in the scenario he
>is looking for, I believe it's an insert...
>
>but seriously a select into is the easiest.
>
>im not sure who the original poster was...but are you looking for a one time
>thing to do, or something to do day to day, etc...?
>
>tony
>
>-----Original Message-----
>From: Tony Weeg [mailto:[EMAIL PROTECTED]
>Sent: Thursday, April 22, 2004 2:09 PM
>To: CF-Talk
>Subject: RE: Generic Table Copy from one DB to another
>
>with cf?
>
><cfquery name="get" datasource="dsn1">
>select * from thisTable
></cfquery>
>
><cfloop query="get">
>
><cfquery name="set" datasource="dsn2">
>insert into newTable
>(column1, column2, column3)
>values
>('#get.value1#','#get.value2#','#get.value3#')
></cfquery>
>
></cfloop>
>
>that's just one way...that I usually use!
>
>-----Original Message-----
>From: Gonzo Rock [mailto:[EMAIL PROTECTED]
>Sent: Thursday, April 22, 2004 1:14 PM
>To: CF-Talk
>Subject: RE: Generic Table Copy from one DB to another
>
>Hey Tony, how ya do this with cf? the query extends across two databases...
>reading source from one and writing to the second... would be great to know.
>thanks.
>
>At 09:51 AM 4/22/04, you wrote:
>
> >ok...
> >
> >here ya go...simple but effective.
> >
> >select *
> >INTO server_B.something.dbo.database_B
> >from server_A.something.dbo.database_A
> >
> >that will take everything from a to b, table structure etc.
> >
> >tw
> >
> >-----Original Message-----
> >From: Richard Crawford [mailto:[EMAIL PROTECTED]
> >Sent: Thursday, April 22, 2004 12:49 PM
> >To: CF-Talk
> >Subject: Re: Generic Table Copy from one DB to another
> >
> >Tony Weeg wrote:
> >
> > > why not use select into?
> >
> >I am still looking for information about select into.
> >
> >--
> >Richard S. Crawford
> >Programmer III,
> >UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
> >(916)327-7793 / [EMAIL PROTECTED]
> >
> >----------
> >[<http://www.houseoffusion.com/lists.cfm/link=t:4>Todays Threads]
> >[<http://www.houseoffusion.com/lists.cfm/link=i:4:160994>This Message]
> >[<http://www.houseoffusion.com/lists.cfm/link=s:4>Subscription]
> >[<http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=664.584.4>
> >Fast
> > Unsubscribe] [<http://www.houseoffusion.com/signin/>User Settings]
> >
> >----------
> ><http://www.houseoffusion.com/banners/view.cfm?bannerid=40>
> >[]
> >
>
>----------
>[<http://www.houseoffusion.com/lists.cfm/link=t:4>Todays Threads]
>[<http://www.houseoffusion.com/lists.cfm/link=i:4:161013>This Message]
>[<http://www.houseoffusion.com/lists.cfm/link=s:4>Subscription]
>[<http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=664.584.4>Fast
> Unsubscribe] [<http://www.houseoffusion.com/signin/>User Settings]
>
>----------
><http://www.houseoffusion.com/banners/view.cfm?bannerid=36>
>[]
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
