Hi,the following error is occuring on my web site (www.municipionline.com.br):

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
keyword 'order'
./estado.asp, line 98

The command used on this line is :
Select * from estado where cod_pais = &session("pais")order by nome_estado

This global variable "pais" is set in the first program that call this module.
It seems that its value is not read by the other programs. It comes blank
when we put a response.write command. Sometimes, when we issue a RELOAD command
it works. Does any anybody know how to fix it ?
Thank you very much.
Regards,
Roberto Marques