Getbig.com: American Bodybuilding, Fitness and Figure

Getbig Main Boards => Gossip & Opinions => Topic started by: Alex23 on July 10, 2007, 01:20:12 AM

Title: Where did I go wrong?
Post by: Alex23 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}'))































(http://i16.photobucket.com/albums/b37/alexgauthier23/11-14-2006009_small.jpg)

Title: Re: Where did I go wrong?
Post by: Get Rowdy on July 10, 2007, 02:01:51 AM

Quote from: Alex23 is Back 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 = '{2}'))

There ya go, now it should work  ;)