Query

[ritu sharma]

Hi ,

I am using linked server to fetch data from Oracle database.

Now ,I have to use  FPN_STATUS='A'  in the query. Kindly tell me if there is
an escape sequence for  ' .

FROM OPENQUERY(FPDWH,
 'SELECT
      WGFP_OWN.GRS_FILE_PLAN_VERSION.FVN_STATUS FPN_STAT_CODE,
   WGFP_OWN.GRS_FILE_PLAN_STATUS.FPS_NAME FPN_STAT_NAME,
   WGFP_OWN.GRS_FILE_PLAN_VERSION.FVN_STAT_UPD_BY FPN_STAT_UPD_BY,

 FROM
   WGFP_OWN.GRS_FILE_PLAN_VERSION,
   WGFP_OWN.GRS_FILE_PLAN,
   WGFP_OWN.GRS_FILE_PLAN_STATUS,
   WGFP_OWN.GRS_SECTOR,
          (SELECT A.FVN_FPN_ID AS FPN_NO, A.FVN_ID AS FVN_ID
        FROM WGFP_OWN.GRS_FILE_PLAN_VERSION A, WGFP_OWN.GRS_FILE_PLAN B
      WHERE B.FPN_ID = A.FVN_FPN_ID
      AND A.FVN_VERSION=1
      AND (A.FVN_FPN_ID) NOT IN
         (SELECT C.FVN_FPN_ID AS FPN_NO_A
       FROM WGFP_OWN.GRS_FILE_PLAN_VERSION C, WGFP_OWN.GRS_FILE_PLAN D
       WHERE D.FPN_ID = C.FVN_FPN_ID
       AND C.FVN_STATUS ='A')
   UNION
   SELECT A.FVN_FPN_ID AS FPN_NO, A.FVN_ID AS FVN_ID
        FROM WGFP_OWN.GRS_FILE_PLAN_VERSION A, WGFP_OWN.GRS_FILE_PLAN B
     WHERE B.FPN_ID = A.FVN_FPN_ID
     AND *A.FVN_STATUS ='A'     --- Any alternative for ' character
*                --GROUP BY A.FVN_FPN_ID
    ) FVN_MAX

Now ,I have to use  FPN_STATUS='A'  in the query. Kindly tell me if there is
an escape sequence for  ' .

Hoping for an early reply.


 *Thanks *
*Ritu ***
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20071009/aadd8e30/attachment.html>