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/
