I´ve got the following query. this query works for SQL SERVER 2000 Spanish but not for English.


ses.CreateSQLQuery("delete from rol_usuariotecnico where idRol=" + rol.IdRol + " AND idUsuario='"+ rol.Usuario.Id + "' AND fechaIni= '" + rol.FechaIni + "' AND fechaFin='" + rol.FechaFin + "'", "borrarRoles", typeof(Incidencia)).List();


The problem is with the format of th dates. How can i solve it?


Borja

I suspect it is an character encoding issue (i.e. Spanish vs. English). I would first try using parameters instead of piecing the SQL together manually.