Resultset Comparison

Ask a Question related to Coldfusion Database Access, Design and Development.

  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. Similar Questions and Discussions

    1. Can not open resultset
      Dear all, could someone help me in such problem: in a loop a make a lot of (ca.1500) inserts to table1. I the some time I make select query on...
    2. Single Quotes in resultset
      :confused; All, I would like some help with the following: I am using an CFStoredProc tag to execute a Stored Procedure I wrote against an MS SQL...
    3. mysql resultset in flash
      i have written a tutorial to bring mysql resultset directly in flash at http://www.19.5degs.com/element/766.php#flash-remoting-using-php. i was...
    4. ResultSet is not updatable.
      hi, i am using db2 v8.1 udb fix pack 2 on NT. db2jcc.jar is the jdbc driver we use, it is type 4. the url is ...
    5. resultset.close()
      hi, i have a sql query be executed up to thousand times, the only change is the where clause value change, so each time i need to create a...
  3. #2

    Default Re: Resultset Comparison

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

Posting Permissions

  • You may not post new threads
  • You may 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