jsp jstl sql strange behaviour with as in mysql

[Pradyut Bhattacharya]

Hi
In mysql i m having a stored procedure which has a sql like:

select firstname as i_firstname , lastname as i_lastname from roleuser 
where user_id = uid ;

I m using a jstl code to get the values: -

<sql:query var="comm_codes" dataSource="jdbc/myDatasource">
    call sp_select_username(?);
    <sql:param>${user_id}</sql:param>
</sql:query>

<c:forEach var="rows" items="${comm_codes.rows}">
    ${rows.i_firstname} ${rows.i_lastname}
</c:forEach>

But this code does not return anything but when the replace the above code ${rows.i_firstname} with ${rows.firstname} i get the correct values.

Anything wrong with jstl, is this replicable or my fault here...

Question also posted here: - http://stackoverflow.com/questions/4998749/jsp-jstl-sql-strange-behaviour-with-as-in-mysql

thanks

[amit punekar]

Hi,
You are selecting i_firstname as firstname(i.e. using aliases in SQL) and that is the reason why it works when you access "rows.firstname".
It is working as expected. Is there any other reason that you think it has strange behaviour?

regds,
Amit

[Stefan Evans]

amit punekar wrote:Hi,
You are selecting i_firstname as firstname(i.e. using aliases in SQL) and that is the reason why it works when you access "rows.firstname".
It is working as expected. Is there any other reason that you think it has strange behaviour?

I would suggest you take a closer look.
What I see is: select firstname as i_firstname

So it is coming back with the column name rather than the alias specified.
Of course that sql is embedded in a stored procedure in some fashion. I'm not entirely certain how a stored procedure is expected to return a result set.

What does the stored procedure you are using look like?

[amit punekar]

Hello,
Yeah that's right. Thanks for pointing this out.
Apologies for not reading the SQL properly..assumed that the query is correct...:-|

regards,
Amit