what does positional and named parameter in a query mean?

Posted by ajsie on Stack Overflow See other posts from Stack Overflow or by ajsie
Published on 2010-04-20T19:55:25Z Indexed on 2010/04/20 20:03 UTC
Read the original article Hit count: 140

Filed under:
|

here we got a positional parameter:

SELECT 
u 
FROM ForumUser u 
WHERE u.id = ?1

and here a named parameter:

SELECT 
u 
FROM ForumUser u 
WHERE u.username = :name

this is DQL (doctrine query language) but i think the concept is the same.

could someone please explain what these mean and do?

© Stack Overflow or respective owner

Related posts about sql

Related posts about dql