Any fields with # in them need to be escaped with ## A.PCVER# AS PCVER,
- should be - A.PCVER## AS PCVER, ..and... WHERE A.Pcpord = "VALUE# - should be - WHERE A.Pcpord = #VALUE# What db is this? That is a freaky looking join with all the (((((((((((((((( in there. Larry On 7/5/05, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: > Hi > I am not sure why i am getting the above error, is > there a way to debug it. > I am going to paste my xml file definiation here, > I am sure this SQL statement works > the error i am getting is as below > Caused by: com.ibatis.sqlmap.client.SqlMapException: > Unrecognized parameter mapping field: ' F.P813NAME AS > P813NAME' in AS BP2FAX, F.P813NAME AS P813NAME, > F.P813PHON AS P813PHON, G.P830DESC AS P830DESC, > A.PCSHPV AS PCSHPV, A.PCFRGT AS PCFRGT, A.PCORIG AS > PCORIG, A.PCCURR AS PCCURR, A.PCEXCG AS PCEXCG, > A.PCBUYR AS PCBUYR, A.PCBLOR AS PCBLOR, A.PCSRCE AS > PCSRCE, A.PCVALU AS PCVALU, A.PCAKDT AS PCAKDT, > A.PCVNDT AS PCVNDT, A.PCFXDT AS PCFXDT, A.PCINDT AS > PCINDT, A.PCSPN1 AS PCSPN1, A.PCSPN2 AS PCSPN2, > A.PCSPN3 AS PCSPN3, A.PCENDU AS PCENDU, A.PCUSF1 AS > PCUSF1, A.PCUSF2 AS PCUSF2, A.PCUSF3 AS PCUSF3, > A.PCSTAT AS PCSTAT, A.PCCANC AS PCCANC, A.PCVER > > > my sql statement is as below > > SELECT A.PCPORD AS PCPORD , > A.PCVALU AS PCVALU , > A.PCPTYP AS PCPTYP , > A.PCODAT AS PCODAT , > A.PCVNDR AS PCVNDR , > A.PCINVV AS PCINVV, > A.PCSHPT AS PCSHPT, > A.PCBILT AS PCBILT, > A.PCCONF AS PCCONF, > A.PCROUT AS PCROUT, > A.PCASTA AS PCASTA, > A.PCAPVU AS PCAPVU, > A.PCAPVD AS PCAPVD, > A.PCAPVT AS PCAPVT, > A.PCPAYT AS PCPAYT, > A.PCDISC AS PCDISC, > C.P2FAX# AS BP2FAX, > F.P813NAME AS P813NAME, > F.P813PHON AS P813PHON, > G.P830DESC AS P830DESC, > A.PCSHPV AS PCSHPV, > A.PCFRGT AS PCFRGT, > A.PCORIG AS PCORIG, > A.PCCURR AS PCCURR, > A.PCEXCG AS PCEXCG, > A.PCBUYR AS PCBUYR, > A.PCBLOR AS PCBLOR, > A.PCSRCE AS PCSRCE, > A.PCVALU AS PCVALU, > A.PCAKDT AS PCAKDT, > A.PCVNDT AS PCVNDT, > A.PCFXDT AS PCFXDT, > A.PCINDT AS PCINDT, > A.PCSPN1 AS PCSPN1, > A.PCSPN2 AS PCSPN2, > A.PCSPN3 AS PCSPN3, > A.PCENDU AS PCENDU, > A.PCUSF1 AS PCUSF1, > A.PCUSF2 AS PCUSF2, > A.PCUSF3 AS PCUSF3, > A.PCSTAT AS PCSTAT, > A.PCCANC AS PCCANC, > A.PCVER# AS PCVER, > A.PCINCO AS PCINCO, > A.PCDATE AS PCDATE, > A.PCTIME AS PCTIME, > A.PCUSER AS PCUSER, > H.P1NAME AS VP1NAME , > H.P1ADR1 AS VP1ADR1 , > H.P1ADR2 AS VP1ADR2 , > H.P1ADR3 AS VP1ADR3 , > H.P1COUN AS VP1COUN , > H.P1PROV AS VP1PROV , > H.P1CITY AS VP1CITY , > H.P1STE AS VP1STE , > H.P1CTRY AS VP1CTRY , > H.P1ZIP AS VP1ZIP , > H.P1TEL# AS VP1TEL , > H.P1FAX# AS VP1FAX , > H.P1MAIL AS VP1MAIL , > H.P1CONT AS VP1CONT , > A.PCSHPT AS PCSHPT, > B.P2NAME AS SNAME, > B.P2ADR1 AS SP2ADR1, > B.P2ADR2 AS SP2ADR2, > B.P2CITY AS SP2CITY, > B.P2STE AS SP2STE , > B.P2ZIP AS SP2ZIP , > B.P2ATTN AS SP2ATTN, > B.P2PHON AS SP2PHON, > B.P2FAX# AS SP2FAX, > C.P2NAME AS BNAME, > C.P2ADR1 AS BP2ADR1, > C.P2ADR2 AS BP2ADR2, > C.P2CITY AS BP2CITY, > C.P2STE AS BP2STE , > C.P2ZIP AS BP2ZIP , > C.P2ATTN AS BP2ATTN, > C.P2PHON AS BP2PHON, > D.P832DESC AS P832DESC, > E.P834DESC AS P834DESC, > J.PDLINE AS PDLINE , > J.PDITEM AS PDITEM , > K.M0DESC AS M0DESC , > J.PDPUME AS PDPUME , > J.PDREQ AS PDREQ , > J.PDRQRD AS PDRQRD , > J.PDRQST AS PDRQST, > J.PDSETP AS PDSETP , > J.PDQTYP AS PDQTYP , > J.PDPRCE AS PDPRCE, > I.SENAME AS SENAME, > L.C803CNAM AS C803NAM, > L.C803GSDS AS C803GSDS, > M.P804DESC AS P804DESC, > N.P039PORD AS P039PORD, > N.P039POLN AS P039POLN, > N.P039DSLN AS P039DSLN, > N.P039QTY AS P039QTY , > N.P039SHIP AS P039SHIP, > N.P039DELV AS P039DELV, > N.P039REQ AS P039REQ , > N.P039COMM AS P039COMM, > P.P2NAME AS PBNAME, > P.P2ADR1 AS PBP2ADR1, > P.P2ADR2 AS PBP2ADR2, > P.P2CITY AS PBP2CITY, > P.P2STE AS PBP2STE , > P.P2ZIP AS PBP2ZIP , > P.P2ATTN AS PBP2ATTN, > P.P2PHON AS PBP2PHON, > P.P2FAX# AS PBP2FAX, > Q.P2NAME AS QBNAME, > Q.P2ADR1 AS QBP2ADR1, > Q.P2ADR2 AS QBP2ADR2, > Q.P2CITY AS QBP2CITY, > Q.P2STE AS QBP2STE , > Q.P2ZIP AS QBP2ZIP , > Q.P2ATTN AS QBP2ATTN, > Q.P2PHON AS QBP2PHON, > Q.P2FAX# AS QBP2FAX, > R.SENAME AS RSENAME, > S.SENAME AS SSENAME > FROM > > > > (((((((((((((((( Pu1012 A left join pu1002 B on > > A.PcShpt = B.P2code ) Left join Pu1002 C > on > A.PcBilt = C.P2code ) Left Join Pu1832 D > on > A.PcShpv = D.P832Code ) Left join Pu1834 E > on > A.PcFRGT = E.P834Code ) Left join PU1813 F > on > A.PCBUYR = F.P813Code) Left join PU1830 G > on > A.PCPAYT = G.P830Code) Left join PU1001 H > on > A.PCVNDR = H.P1VNDR) Left join SE1001 I > on > A.PCAPVU = I.SEUSID) Left join CF1803C L > on > A.PCCOMP = L.C803COMP) Left join PU1804 M > on > A.PCptyp = M.p804code) Left join pu1013 J > on > A.pcpord = J.pdpord) Left join pu1039 N > on > J.pdpord = N.p039pord and > > J.pdline = N.p039poln) LEFT JOIN PU1002 P > ON > J.PDSHIP = P.P2CODE) LEFT JOIN PU1002 Q > ON > N.P039SHIP = Q.P2CODE) LEFT JOIN SE1001 R > ON > N.P039REQ = R.SEUSID) LEFT JOIN SE1001 S > ON > J.PDRQST = S.SEUSID), > > > > RS1002 K > > > > WHERE A.Pcpord = "VALUE# > > And A.Pcpord = J.pdpord > > AND J.PDITEM = K.M0CODE > > Order by PDLINE > > > > > > > > > > __________________________________ > Discover Yahoo! > Use Yahoo! to plan a weekend, have fun online and more. Check it out! > http://discover.yahoo.com/ >
