Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Diffrence of parameter format
Diffrence of parameter format [message #389700] Wed, 17 June 2009 16:59 Go to next message
John Z is currently offline 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
Re: Diffrence of parameter format [message #389701 is a reply to message #389700] Thu, 18 June 2009 13:52 Go to previous message
James Sutherland is currently offline 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
Previous Topic:question on ClassNotFoundException: org.eclipse.persistence.sdo.SDOResolvable
Next Topic:fetch multi-level relations
Goto Forum:
  


Current Time: Sat Sep 20 16:15:51 GMT 2014

Powered by FUDForum. Page generated in 0.09980 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software