The following error appears:
Incorrect syntax near '='.: SELECT "dbo"."Articles"."Id",
("dbo"."Articles"."TypeId" = '1') AS expr20999ef3, ("dbo"."Articles"."TypeId" =
'2') AS expr20999fad FROM "dbo"."Articles" WHERE (("dbo"."Articles"."TypeId" =
'1') OR ("dbo"."Articles"."TypeId" = '2')) (E0)
> Subject: Re: [d2rq-dev] d2rq:condition over the same table column
> From: rich...@cyganiak.de
> Date: Thu, 7 Mar 2013 10:56:49 +0000
> CC: d2rq-map-devel@lists.sourceforge.net
> To: e.jaj...@hotmail.com
>
> On 7 Mar 2013, at 10:18, Edmond Jajaga wrote:
> > In your response
> > http://www.mail-archive.com/d2rq-map-devel@lists.sourceforge.net/msg00565.html
> > your college is saying to replace the map label. For the person who is
> > asking the solution has worked out out, but in my case the WHERE clause
> > error still appears.
>
> What kind of error appears? (The email you're referring to doesn't mention
> any error, it just mentions a SQL query that generates zero results.)
>
> > Here is my mapping snippet:
> >
> > map:Books a d2rq:ClassMap;
> > d2rq:uriPattern "Articles/@@dbo.Articles.Id@@";
> > d2rq:condition "dbo.Articles.TypeId = '1'";
> > d2rq:class bbb:Books;
> > .
> > map:Notebooks a d2rq:ClassMap;
> > d2rq:uriPattern "Articles/@@dbo.Articles.Id@@";
> > d2rq:condition "dbo.Articles.TypeId = '2'";
> > d2rq:class bbb:Notebooks;
> > .
> >
> > My idea is to populate classes based on the article's TypeId.
>
> This looks like it should work.
>
> Best,
> Richard
>
>
>
>
> >
> > Thank you,
> >
> > Edmond
> > ------------------------------------------------------------------------------
> > Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester
> > Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the
> > endpoint security space. For insight on selecting the right partner to
> > tackle endpoint security challenges, access the full report.
> > http://p.sf.net/sfu/symantec-dev2dev_______________________________________________
> > d2rq-map-devel mailing list
> > d2rq-map-devel@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
>
------------------------------------------------------------------------------
Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester
Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the
endpoint security space. For insight on selecting the right partner to
tackle endpoint security challenges, access the full report.
http://p.sf.net/sfu/symantec-dev2dev
_______________________________________________
d2rq-map-devel mailing list
d2rq-map-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
