ERROR: Non-integer constant in ORDER BY

[Antonio Gallardo Rivera <ag...@agsoftware.dnsalias.com>]

I am using Cocoon 2.1. I have the following ESQL:

<esql:query>
	SELECT cat_id, cat_nombre, cat_habilitado
	FROM categoria
	WHERE cat_nombre LIKE <esql:parameter>%<xsp-request:get-parameter
		name="nombre"/>%</esql:parameter>
	AND cat_habilitado LIKE <esql:parameter>%<xsp-request:get-parameter
		name="habilitado"/>%</esql:parameter>
	ORDER BY <xsp-request:get-parameter name="orden"/>
</esql:query>

This last line is not working well:

	ORDER BY <xsp-request:get-parameter name="orden"/>

The curious is that the parameter is getted from:

<select name="orden">
	<option value="cat_nombre">Nombre</option>
	<option value="cat_habilitado">Habilitado</option>
</select>

Then there is no way the user can left it in blank!

What I am doing wrong?

Regards,

Antonio Gallardo

---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>