Professional Web Applications Themes

Resultset Comparison - Coldfusion Database Access

Hi, I have two resultsets from 2 different datasource. Say DSN1 and DSN2. I need to Compare and display if this condition is true..DSN1.FIELD1=DSN2.FIELD1. Can any body help me out..?.I can't use PL/SQL procedures as the 2 databases are different instances of Oracle. Thx for ur Help with regards AL...

  1. #1

    Default Resultset Comparison

    Hi,
    I have two resultsets from 2 different datasource.
    Say DSN1 and DSN2.
    I need to Compare and display if this condition is
    true..DSN1.FIELD1=DSN2.FIELD1.
    Can any body help me out..?.I can't use PL/SQL procedures as the 2 databases
    are different instances of Oracle.
    Thx for ur Help

    with regards
    AL


    alagukannan Guest

  2. #2

    Default Re: Resultset Comparison

    sounds like a job for query of queries.
    Dan Bracuk Guest

Similar Threads

  1. Can not open resultset
    By Rob in forum MySQL
    Replies: 2
    Last Post: May 21st, 07:49 PM
  2. Single Quotes in resultset
    By timstsprymsn in forum Macromedia ColdFusion
    Replies: 1
    Last Post: March 16th, 10:37 PM
  3. mysql resultset in flash
    By robin kohli in forum Macromedia Flash
    Replies: 1
    Last Post: November 1st, 02:36 AM
  4. ResultSet is not updatable.
    By xixi in forum IBM DB2
    Replies: 7
    Last Post: August 7th, 10:53 PM
  5. resultset.close()
    By xixi in forum IBM DB2
    Replies: 3
    Last Post: July 14th, 05:04 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