This topic is locked

3.2 Search error

4/28/2005 4:30:53 AM
ASPRunnerPro General questions
Alberto author

This is the error and also it get mixed when I try with others fields too
Technical information

Error number -2147217900

Error description [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'NumeroContrato'.

URL /test/test3/tbContratos_list.asp

SQL query
select [NumeroContrato], [NumeroAgendamiento], [UsuarioCobranzas], [NombreDestinatario], [FechaVenta], [FechaEntrega], [CodigoAsesor], [NombreEnvio], [DireccionEnvio], [CiudadEnvio], [EstadoRegionEnvio], [CodigoPostalEnvio], [PaisEnvio], [TelefonoContacto], [InstruccionesEspeciales], [PrecioContado], [CostoEnvio], [Impuesto], [TotalContado], [PrePaidAmount], [PrePaidMetodo], [CODAmount], [CODMetodo], [DownPayment], [AFinanciar], [Interes], [BalanceTotal], [NumeroCuotas], [MontoCuota], [TotalAPagar], [FormaPago], [AreaVentas], [Status], [FechaSolicitudDespacho], [EntidadDestino], [EmailDestino], [UsuarioDespacho], [ShipVia], [Puntaje], [UsuarioVerificacion]
From [dbo].[tbContratos]
where upper([NumeroContrato] )=upper('MOR0000004') NumeroContrato

Sergey Kornilov admin 5/4/2005

Hi,
Please zip and send to support@xlinesoft.com all files from ASPRunnerPro output folder with subfolders along with project file and your sample database. I'll find what's wrong running it on my test box.