Professional Web Applications Themes

Using CFML to Backup (duplicate) tables into the same orSecond MDB - Coldfusion Database Access

Removed by Administrator...

  1. Moderated Post

    Default Using CFML to Backup (duplicate) tables into the same orSecond MDB

    Removed by Administrator
    bigbrain28 Guest
    Moderated Post

  2. #2

    Default Re: Using CFML to Backup (duplicate) tables into thesame or Second MDB

    For the record, there are probably more efficient ways to accomplish your goal,
    but, if this is what you want to do,

    Make sure the databases can select from each other.

    Then write your queries something like this: note that you are backing up db1
    into db2


    delete from db2.tablename

    insert into db2.tablename
    select * from db1.tablename


    Dan Bracuk Guest

Similar Threads

  1. Flash and CFML
    By idesdema in forum Coldfusion Flash Integration
    Replies: 1
    Last Post: April 11th, 08:23 PM
  2. Accessing duplicate field names from different tables
    By cakesy in forum Coldfusion Database Access
    Replies: 7
    Last Post: March 10th, 09:45 AM
  3. Replies: 2
    Last Post: March 9th, 11:54 PM
  4. use cfml in JS
    By [lb]Sonix in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: February 17th, 12:24 PM
  5. loop - begin backup, end backup Oracle 8.1.7
    By Matthias Arth in forum Oracle Server
    Replies: 1
    Last Post: December 27th, 08:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139