Hibernate Community • View topic - using strings in named query

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

using strings in named query

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

mc1392-c

Post subject: using strings in named query

Posted: Fri Dec 05, 2008 4:59 pm

Newbie

Joined: Fri Dec 05, 2008 4:55 pm
Posts: 1

I'd like to use some strings in a named query.

[code]
<query name="tradeloader.getPositions">from Position where cusip= :cusip and dealernumber= :dealernumber</query>
[/code]
This works.

I'd like to add accountsource='DST' or accountsource='TDA'

How can I do this with the named query?
I tried this, but no good:

[code]
<query name="tradeloader.getPositions">from Position where cusip= :cusip and dealernumber= :dealernumber accountsource='TDA'</query>
[/code]

Even if I lose the single quotes still no good.
Any ideas?

Top

croudet

Post subject:

Posted: Fri Dec 05, 2008 5:25 pm

Regular

Joined: Mon Apr 19, 2004 6:54 pm
Posts: 79

You can try this:

Code:

<query name="tradeloader.getPositions"><![CDATA[
from Position where cusip= :cusip and dealernumber= :dealernumber and accountsource='TDA'
]]></query> 

Christophe

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum