Thanks Ian, there's really only 4-5 records at a transaction, so it should
run OK.

Thanks, Mark

  _____  

From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Friday, May 28, 2004 12:42 PM
To: CF-Talk
Subject: RE: Looping a returned query to insert into another table

Simply put a query loop around the insert block.

<cfloop query = "resultSet">
    <cfquery ...>
        INSERT INTO ....

    </cfquery>
</cfloop>

Now this is where CF may become not the best choice for a feature.  If one
needs to thousand and thousands of records this way, the template will
easily become very slow running and may timeout or have other problem.  

--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

"C code. C code run. Run code run. Please!"
     - Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to