Author Topic: Where did I go wrong?  (Read 1068 times)

Alex23

  • Guest
Where did I go wrong?
« on: July 10, 2007, 01:20:12 AM »
You all getbiggers who know it all about every shit, from politics to who's GH15...


What's wrong with this?  ;D  ;D  ;D  ;D


SELECT EX.EXECUTABLE_ID,
       REPLACE (C.GENERATED_KEY, {0}, (SELECT GENERATED_ID
                                            FROM DP_TARGET_MAP))
  FROM DP_COLUMN C, DP_EXECUTABLE EX
 WHERE EX.EXECUTABLE_ID = C.EXECUTABLE_ID
   AND C.GENERATED_KEY LIKE '%{0}%'
   AND EX.DATA_SET_ID = (SELECT EX.EXECUTABLE_ID, EX.NAME, EX.GENERATED_KEY
                           FROM DP_EXECUTABLE EX
                          WHERE EX.DATA_SET_ID = (SELECT DATA_SET_ID
                                                    FROM DP_DATA_SET DS
                                                   WHERE DS.DATA_SET = '{1}'))
































Get Rowdy

  • Getbig IV
  • ****
  • Posts: 1704
Re: Where did I go wrong?
« Reply #1 on: July 10, 2007, 02:01:51 AM »
You all getbiggers who know it all about every shit, from politics to who's GH15...


What's wrong with this?  ;D  ;D  ;D  ;D


SELECT EX.EXECUTABLE_ID,
       REPLACE (C.GENERATED_KEY, {0}, (SELECT GENERATED_ID
                                            FROM DP_TARGET_MAP))
  FROM DP_COLUMN C, DP_EXECUTABLE EX
 WHERE EX.EXECUTABLE_ID = C.EXECUTABLE_ID
   AND C.GENERATED_KEY LIKE '%{0}%'
   AND EX.DATA_SET_ID = (SELECT EX.EXECUTABLE_ID, EX.NAME, EX.GENERATED_KEY
                           FROM DP_EXECUTABLE EX
                          WHERE EX.DATA_SET_ID = (SELECT DATA_SET_ID
                                                    FROM DP_DATA_SET DS
                                                   WHERE DS.DATA_SET = '{2}'))




There ya go, now it should work  ;)