Re: about query with order by question
belingueres@gmail.com schrieb:
> Hi,
>
> I have the following query working in several databases:
>
> select fingerprint
> from CertificateData
> where> status=?
> and issuerDN=?
> ORDER BY expireDate DESC
>
> but it refuses to work on Informix since the attribute expireDate in
> the order by clause is not in the select list (exact error message is:
> ORDER BY column (expiredate) must be in SELECT list)
>
> Since this form of select query with the order by clause is allowed in
> many DBMS like MySQL, Oracle, MS SQL Server and Sybase, I wonder if
> there are some configuration flag or something that allow Informix to
> accept this (popular?) query syntax.
>
> Any help will be appreciated.
>
> Regards,
> Gabriel
It's possible since 9.40, not with 9.30.
Regards,
try_and_err