> 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!
Spiffy!
Is there a way to do this without specifically listing all of the table
names?
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
