Like I said...Cint()

sqlcodmod="select Cint(codmodulo) as codmodulo from modasg where cod='"&request("cod")&"'" 

>Thanks for your post and i made the changes you suggested but it shows the next message error:
>
>Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
>[MySQL][ODBC 3.51 Driver][mysqld-3.23.49-max]You have an error in your SQL syntax near '(int,codmodulo) from modasg where cod='123'' at line 1
>/callc/Ing_modulos.asp, line 22
>
>
>this is my code at line 22:
>

>sqlcodmod="select convert(int,codmodulo) from modasg where cod='"&request("cod")&"'"
>   set rscodmod=conn.execute(sqlcodmod)
>

>
>Am i doing smothing wrong?
>Thanks for your help.