Josh
An INSERT SELECT would certainly be the best method to
copy row(s) from one table to another in the same
database but he has different datasources set
up in each query so I don't think that would work
in this case.
Tristram Charnley
-----------------
[EMAIL PROTECTED]
> -----Original Message-----
> From: Joshua Meekhof [mailto:[EMAIL PROTECTED]]
> Sent: 01 May 2001 16:54
> To: CF-Talk
> Subject: Re: I'm sure this worked earlier
>
>
> Darren,
>
>
> I have a few questions / comments.
>
> 1) Why do you convert the query, which is conceptually a structure of
> arrays into an array of structures?
>
> 2) Why don't you insert the records into the data base in one
> step? e.g.
> <cfquery>
> insert into pressoffice
> (headline,subtitle,body,date,expdate,country,live,author)
>
> select headline, subtitle, body,date,expdate,country,live,author
> from pressrelesetable where live =1
> </cfquery>
>
> 3) Try using SQL comments "--" in your query instead of Cold Fusion
> comments.
>
> --
> Josh Meekhof
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
