Algien Puede Decir Que Tiene Mal

[viqtor]

ESTE ES EL CODIGO:

if (isset($_POST['vende']) && isset($_POST['fechain'])&& isset($_POST['fechaf'])) {


$FI = $_POST['fechain'];
$FF = $_POST['fechaf'];
$ven = $_POST['vende'];
$producto = "1";

$consulta= "SELECT C.cod_cte, C.razon_social, isnull((select top 1 fecha from entysal where status <> 'C' and fecha between '@FI' and '@FF' and cod_cte = C.cod_cte and vendedor = '@vendedor' and cod_prod = '@producto' and transaccion in ('36','37','38') order by fecha desc),'') as ultima_venta, isnull((select top 1 fecha from mpedcte where status <> 'C' and fecha between '@FI' and '@FF' and cod_cte = C.cod_cte and vendedor = '@vendedor' and cod_prod = '@producto' and transaccion = '31' order by fecha desc),'') as ultima_pedido, isnull((select sum(cantidad) from entysal where folio in (select top 1 folio from entysal where status <> 'C' and fecha between '@FI' and '@FF' and cod_cte = C.cod_cte and vendedor = '@vendedor' and cod_prod = '@producto' and transaccion in ('36','37','38') order by fecha desc)),0.0) as cantidad_venta, isnull((select sum(cantidad_pedida) from mpedcte where folio in (select top 1 folio from mpedcte where status <> 'C' and fecha between '@FI' and '@FF' and cod_cte = C.cod_cte and vendedor = '@vendedor' and cod_prod = '@producto' and transaccion = '31' order by fecha desc)),0.0) as cantidad_pedido, isnull((select status from pedcte where folio in (select top 1 folio from mpedcte where status <> 'C' and fecha between '@FI' and '@FF' and cod_cte = C.cod_cte and vendedor = '@vendedor' and cod_prod = '@producto' and transaccion = '31' order by fecha desc)),'') as status_pedido FROM CLIENTES C where vendedor = '@vendedor'" ;

$consulta = str_replace('@FI',$FI,$consulta);
$consulta = str_replace('@FF',$FF,$consulta);
$consulta = str_replace('@vendedor',$ven,$consulta);
$consulta = str_replace('@producto',$producto,$consulta);
}
?>

<?php

$result = mssql_query($consulta);
while( $row = mssql_fetch_array( $result ) ){
//cierra mas abajo ?>

Y ME MANDA EL SIGUIENTE ERROR

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\areacomercial.starfruts.com.mx\vend edor01.php on line 124

Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\areacomercial.starfruts.com.mx\vend edor01.php on line 125

[mauled]

Te sugiero que modifiques esta linea

Código PHP:

  $result = mssql_query($consulta);  
   

por

Código PHP:

  $result = mssql_query($consulta)or or exit(mssql_get_last_message());  
   

Y veas que error esta teniendo tu query.

Saludillos

[viqtor]

YA hice el cambio que me sugeriste y me regresa este error:

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\areacomercial.starfruts.com.mx\vend edor01.php on line 124
Changed database context to 'BMS_2004'.

$link = mssql_connect ($host, $user, $password) or die ("<center>No se puede conectar con la base de datos\n</center>\n");
mssql_select_db(BMS_2004) or die("Imposible seleccionar la base de datos. Porfavor, intentelo mas tarde");

Ese es el nombre correcto de mi base