Actually, I figured it out.
Here is a snippet from my query:
"
JOIN item.department AS d
JOIN user.baseObject AS r
ON item.item.requester
OUTER JOIN item.itemSpecialist is
"
Notice, after my OUTER JOIN I have "is", which I intended to be an
alias, but I forgot to put "AS is". Once I put that, I realized that
"is" is a reserved word (don't call me a rookie, I promise I'm not!),
and changed the alias to something else. Now everything works
correctly.
False alarm.
Thank you for this great system Mark!
-Denver Root
On Aug 31, 3:49 pm, Denver <[email protected]> wrote:
> I have a TQL query with a Where clause that has been running fine.
> Today, I added a "OUTER JOIN" to the query, and suddenly my Where
> clause is getting discarded... I checked and the where clause is
> still getting passed to CreateQuery(), but it is NOT making it into
> the final query which is sent to my SQL Server.
>
> What is going on?
--~--~---------~--~----~------------~-------~--~----~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
You received this message because you are subscribed to the Google Groups
"transfer-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
