Eclipse Community Forums: EclipseLink » Diffrence of parameter format

Help

Home

Home » Eclipse Projects » EclipseLink » Diffrence of parameter format

Show: Today's Messages :: Show Polls :: Message Navigator

Diffrence of parameter format [message #389700]

Wed, 17 June 2009 16:59

John Z

Messages: 1
Registered: July 2009

Junior Member

Hi,
i have named query with parameters, both of following format seems working:

select * from table_a where row_id=?id
select * from table_a where row_id=:id

What are the diffrence of them?

Thanks

Report message to a moderator

Re: Diffrence of parameter format [message #389701 is a reply to message #389700]

Thu, 18 June 2009 13:52

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

No real difference.

Normally : is used for named parameters, and ? is used for positional
parameters.

---
James
http://www.nabble.com/EclipseLink---Users-f26658.html

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	question on ClassNotFoundException: org.eclipse.persistence.sdo.SDOResolvable
Next Topic:	fetch multi-level relations

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 06:18:16 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter