Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote -1 down vote favorite

I need to add a symbol with the value of self.wrkArea variable like this

(select chr(182) from dual) || self.wrkArea || (select chr(182) from dual)

i.e. ¶workarea¶ will be the result. how to substitute this in below query?

can anyone plz help me

cursor.execute("""insert into MDP_ERR_MASTER (MARKERID, FILENAME, ERRORCODE, USERID, CHECKEDBY, CHECKEDDT, STATUS, COMMENTS, X1, Y1, Z1, X2, Y2, Z2, RECNO, PROJECT_CODE, SRC_ACC_NUM, WORKAREA, CONFIGID, ELEMENTID)
            values (:markerid,:shapename,:errcode,'0',:sysid,sysdate,'OPEN',:usercomment,:x1,:y1,0,:x2,:y2,0,1,:jobno,:srcacnum,:workarea,0,0)""",
            {"markerid" : markerId,
             "shapename" : str(errorMarkerLayer.name()),
             "errcode" : errCode ,
             "sysid" : self.sysid ,
             "usercomment" : str(comments),
             "x1" : startPnt[0],
             "y1" : startPnt[1],
             "x2" : endPnt[0],
             "y2" : endPnt[1],
             "jobno" : self.jobNo,
             "srcacnum" : src_AcNum,
             "workarea" : self.wrkArea
             })
share|improve this question
3  
I cannot see any GIS software in this question and recommend you post it to StackOverflow instead. – PolyGeo May 3 at 7:53

closed as off topic by PolyGeo, blah238, BradHards, vinayan, Fezter May 3 at 11:41

Questions on Geographic Information Systems Stack Exchange are expected to relate to geographic information systems within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.