Solved

Display problem

Posted on 2002-04-04
14
213 Views
Last Modified: 2008-03-17
I made a PHP class function which generate a HTML page with the results of a ORACLE query.

All works fine except that sometimes the process stop in the middle of it and the page stop being displayed.

I need any idea what thing I should test (buffers,etc).

by Now I test.

1) Format of the HTML page displayed which is correct in spite of all the conditions I have to display it.
2) Any of the conditions inside the loop I use to display the page Don't return NULL values.

3) The problem happened after I call the function many times 5 or 6. Never the first time....
4) Inside the function I made 8 different query's and create 5 cursors....


Any idea would be useful???

Thanks,
Fernando




0
Comment
Question by:Pampa
  • 6
  • 6
  • 2
14 Comments
 
LVL 5

Expert Comment

by:andriv
ID: 6918677
It is really hard to help without any code to go by.  It has to be something in the code.
0
 
LVL 1

Author Comment

by:Pampa
ID: 6918738
Ok.
First "Code the pHP wich call the class function (Reclamos is the name of it)."
--------------------------------------------------

<?php
    if ($PHPSESSID){

        session_start();      
     
       if ($win == "S"){
           include("..\LibreriaBD.php");
           include("..\LibreriaHTML.php");
           include("..\VarConfig.php");
           include(".\LibreriaReclamos.php");
       }else{    
            include("../LibreriaBD.php");
            include("../LibreriaHTML.php");
            include("../VarConfig.php");
            include("./LibreriaReclamos.php");
      }
      $BDClass   = new BDClass;
      $HTMLClass = new HTMLClass;
      $RecClass =  new RecClass;
 
   
    }
    if (!(isset($grupos))){
        session_register('grupos');
    }    
    if (!(isset($grupos))){
        session_register('permisos');
    }  
    if (!(isset($ingresar))){
        session_register('ingresar');
    }  

    if (!isset($IDgrpprim)){
      session_register('IDgrpprim');
    }

   $orden ='';
   $OrdenUser='';
   $OrdenEmp='';
   while (list($var_name,$var_value)=each($HTTP_GET_VARS)){
         if ($var_name == "SORT"){
            $orden = $var_value;
         }
         if ($var_name == "SORTUser"){
            $OrdenUser = $var_value;
         }
         if ($var_name == "SORTUserU"){
            $OrdenUbic = $var_value;
         }
         if ($var_name == "SORTEmp"){
            $OrdenEmp = $var_value;
         }
         if ($var_name == "VISTA"){
            $vista = $var_value;
         }
         if ($var_name == "ADMIN"){
            $admin = $var_value;
         }
         if ($var_name == "SORTPRO"){
            $OrdenPRO = $var_value;
         }
         if ($var_name == "POS"){
            $indice = $var_value;
         }

   
   }
   
 
    $titulo="Reclamos";
    $nivel=2;
    $HTMLClass->EncabezadoREC($titulo,$color_fondo,$imagen_fondo,$nivel,$servidor);
   
    if ($ingresar == "TRUE") {  
       $BDClass->ambiente();      
       $connection = $BDClass->conectarse($BD);
       $ImagenNivel=2;
       if ($admin != ""){          
           $orden = "REC_NroRef";
           $RecClass->FramesReclamos($grupos,$BDClass,$HTMLClass,$BD,$connection,$permisos,$orden,$OrdenUser,$OrdenEmp,$ImagenNivel,$vista,$admin,$nombre,$apellido,$servidor);
       }else{
            if ($vista == ''){
               $vista = "SR";
            }                                                                                              
           $RecClass->Reclamos($grupos,$BDClass,$HTMLClass,$BD,$connection,$permisos,$orden,$OrdenUser,$OrdenEmp,$ImagenNivel,$vista,$estado,$servidor,$OrdenPRO,$IDgrpprim,$OrdenUbic,$indice,$despliega);
       }
    }else{
           session_destroy();
           $msg = "A terminado la sesisn";
           $HTMLClass->FinSesion($msg);
     }


?>

// Code of the function the problem happens inside the MAIN loop
******************************************************

<?php
class RecClass {

function Reclamos($grupos,$BDClass,$HTMLClass,$BD,$connection,$permisos,$orden,$OrdenUser,$OrdenEmp,$ImagenNivel,$vista,$estado,$servidor,$OrdenPRO,$IDgrpprim,$OrdenUbic,$indice,$despliega){

   $listacursor   = $BDClass->abrir($BD,$connection);
   $cursor        = $BDClass->abrir($BD,$connection);
   $cursuser      = $BDClass->abrir($BD,$connection);
   $curgrp        = $BDClass->abrir($BD,$connection);
   $curtemp       = $BDClass->abrir($BD,$connection);

   //**********************************
   // Calculo los Permisos del Usuario
   //**********************************

   $actual= "Cambiar Prioridad:";
   $GruposAsigPRIO =$HTMLClass->TienePermLista($permisos,$actual);

   $actual= "Cambiar Asignacion:";
   $GruposAsig = $HTMLClass->TienePermLista($permisos,$actual);

   $perm= "Ver TODO";
   $ESadmin = $HTMLClass->TienePerm($permisos,$perm);  

   $perm= "Modificar Reclamos:";
   $GruposModif = $HTMLClass->TienePermLista($permisos,$perm);

   if ($vista ==''){
      $vista ="SR";
      $orden = "REC_NroRef";
   }

   //**********************************
   // FIN Calculo Permisos del Usuario
   //**********************************

   $titulo     = "Ingreso de Reclamos";
   $nivel=1;

echo "<BODY background=\"http://$servidor/Helpdesk/Reclamos/images/background.gif\" >\n";

echo "<CENTER>\n";
echo "  <TABLE class =\"Uno\" width=\"99%\" valign=\"top\">\n";       
echo "    <TR> \n";
echo "      <TD> \n";
echo "        <P> \n";
echo "          <CENTER>\n";
echo "          <FONT face=\"Times New Roman\" color=\"#000080\" size=4></FONT></B>\n";
echo "          </CENTER>\n";
echo "          <BR>\n";
echo "        <CENTER>\n";
echo "        <P> \n";
echo "        <TABLE class =\"Uno\" width=\"100%\">\n";
echo "             <TR> \n";
echo "                <TD class= \"blanco\" width=\"25%\">&nbsp;</TD>\n";
echo "                <TD class= \"blanco\" width=\"25%\">&nbsp;</TD>\n";
echo "                <TD class= \"blanco\" width=\"50%\"></TD>\n";
echo "             </TR>\n";
echo "        </TABLE>\n";
echo "        <TABLE class=\"Dos\" width=\"100%\" height=\"56\">\n";
echo "           <TR> \n";
echo "              <TD class = \"borde\" width=\"100%\" height=\"53\"> \n";
echo "              <TABLE class=\"Dos\" width=\"100%\" align=\"left\" height=\"61\" >\n";
echo "                  <TR> \n";
echo "                    <td class=\"inicial\" width=\"8%\" height=\"22\" ><font class=\"arial\">&nbsp;&nbsp;<font size=\"-1\">&nbsp;</font><font class=\"arial\"><a \n";
echo "                        href=\"http://$servidor/Helpdesk/Reclamos/SortReclamos.php?SORT=REC_NroRef&VISTA=$vista&POS=0\">Nro</a> &nbsp;</font></font></td>\n";
echo "                    <td class=\"inicial\" width=\"10%\" height=\"22\" ><font class=\"arial\">&nbsp;<a href=\"http://$servidor/Helpdesk/Reclamos/SortReclamos.php?SORT=REC_Prioridad&VISTA=$vista&POS=0\">Prioridad</a> &nbsp;</font></td>\n";
echo "                    <td class=\"inicial\" align=middle width=\"20%\" height=\"22\" > \n";
echo "                      <font class=\"arial\">&nbsp;&nbsp;</font><font class=\"arial\" size=1><a href=\"http://$servidor/Helpdesk/Reclamos/SortReclamos.php?SORT=REC_Fecha&VISTA=$vista&POS=0\">Fecha/Hora</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></td>\n";
echo "                    <td class=\"inicial\" width=\"16%\" height=\"22\"> \n";
echo "                      <p align=\"center\"><font class=\"arial\" size=1><a href=\"http://$servidor/Helpdesk/Reclamos/SortReclamos.php?SORTPRO=REC_COMUN_ID&VISTA=$vista&POS=0\">Problema</a></font></p></td>\n";
echo "                    <td class=\"inicial\" align=middle width=\"7%\" height=\"22\" > \n";
echo "                      <p align=\"center\"><font class=\"arial\" size=1><a href=\"http://$servidor/Helpdesk/Reclamos/SortReclamos.php?SORTEmp=REC_Emp_ID&VISTA=$vista&POS=0\">Usuario</a></font></p></td>\n";
echo "                    <td class=\"inicial\" align=middle width=\"10%\" height=\"22\" > \n";
echo "                      <p align=\"center\"><font class=\"arial\" size=1><a href=\"http://$servidor/Helpdesk/Reclamos/SortReclamos.php?SORTUserU=REC_Usr_ID&VISTA=$vista&POS=0\">Ubicacion</a></font></p></td>\n";
echo "                    <td class=\"inicial\" width=\"8%\" height=\"22\"> \n";
echo "                      <p><font class=\"arial\" size=1>&nbsp;<a href=\"http://$servidor/Helpdesk/Reclamos/SortReclamos.php?SORTUser=REC_Usr_ID&VISTA=$vista&POS=0\">Tecnico</a></font></p></td>\n";
echo "                  </TR>\n";

if ($vista == "ALL"){
   $texto = "REC_ESTADO LIKE '%SR%' OR REC_ESTADO LIKE '%EP%' OR REC_ESTADO LIKE '%EE%' ";
}else{
   $texto = "REC_ESTADO LIKE '$vista' ";
}
if ($ESadmin == "T"){
   
    $consulta = "SELECT REC_NroRef,REC_Estado,to_char(REC_Fecha,'dd/mm/yyyy - hh24:mi'),REC_COMUN_ID,
                 REC_Prioridad,REC_Descripcion,REC_USR_ID,to_char(REC_Fecha_SOL,'dd/mm/yyyy - hh24:mi'),
                 REC_GRP_ID,REC_Solucion,REC_EMP_ID
                 FROM Reclamos where (" . $texto. "  ";
    $constotal = "SELECT COUNT(Rec_NroRef) from RECLAMOS where (" . $texto. "  ";

}else{
     $consulta = "SELECT REC_NroRef,REC_Estado,to_char(REC_Fecha,'dd/mm/yyyy - hh24:mi'),REC_COMUN_ID,
                  REC_Prioridad,REC_Descripcion,REC_USR_ID,to_char(REC_Fecha_SOL,'dd/mm/yyyy - hh24:mi'),
                  REC_GRP_ID,REC_Solucion,REC_EMP_ID
                  FROM Reclamos where (". $texto . " ) " ;
     $constotal = "SELECT COUNT(Rec_NroRef) from RECLAMOS where (" . $texto. " ) ";
     
     $nombres =split(",",$grupos);
     $cant=count($nombres);
     $i=0;
     foreach ($nombres as $name){
             $consgrp= "SELECT GRP_ID from Grupos WHERE GRP_Nombre = '$name'";
             $BDClass->SQL_CONSULTA($BD,$consgrp,$curgrp);
             $id       = $BDClass->columna($BD,$curgrp,0);        
             if ($id !=''){
                if ($i==0){  
                   $consulta = $consulta . " AND (REC_GRP_ID =$id ";
                   $constotal = $constotal . " AND (REC_GRP_ID =$id ";
                }else{
                     $consulta = $consulta . " OR REC_GRP_ID =$id ";
                     $constotal = $constotal . " OR REC_GRP_ID =$id ";
                }
                $i++;
             }
    }
}

if ($OrdenUser !=''){
    $consulta = $consulta . " ) ORDER by (SELECT Usr_Apellido FROM Usuarios where USR_ID =REC_USR_ID)";
}else{
     if ($OrdenUbic !=''){
         $consulta = $consulta . " ) ORDER by (SELECT Emp_Ubicacion FROM Empleados where EMP_ID =REC_EMP_ID)";
     }else{
          if ($OrdenEmp !=''){
             $consulta = $consulta . " ) ORDER by (SELECT Emp_Apellido FROM Empleados where EMP_ID =REC_EMP_ID)";
          }else{
               if ($OrdenPRO !=''){
                  $consulta = $consulta . " ) ORDER by (SELECT COMUN_TEXTO FROM Comunes where COMUN_ID =REC_COMUN_ID)";
               }else{
                     if ($orden == ''){
                        $orden ="REC_NroRef";
                     }
                     $consulta = $consulta . " ) ORDER by ".$orden;
              }
          }
     }
}
$constotal = $constotal . " ) ";

$BDClass->SQL_CONSULTA($BD,$consulta,$listacursor);
array($result);
while ($result = $BDClass->Obtengo_linea($BD,$listacursor)){

       $NroReclamo  = chop($result[0]);
       $Estado      = chop($result[1]);
       $Fecha       = chop($result[2]);        
       $Titulo      = chop($result[3]);
       $Prioridad   = chop($result[4]);
       $Descripcion = chop($result[5]);
       $Usuario     = chop($result[6]);
       $FechaSol    = chop($result[7]);
       $Grupo       = chop($result[8]);
       $Solucion    = chop($result[9]);
       $Empleado    = chop($result[10]);

      //******************************************************************************************
   
      // Permiso para la Prioridad

       $imagen = $HTMLClass->Imagenes($ImagenNivel,$Prioridad);
       $tienePRIO = $HTMLClass->RegValeLine($BD,$GruposAsigPRIO,$BDClass,$curtemp,$Usuario,$Grupo);

       //Titulo del Problema

       $cons = "SELECT COMUN_TEXTO FROM Comunes where COMUN_ID=$Titulo";
       $BDClass->SQL_CONSULTA($BD,$cons,$curtemp);
       $NTitulo         = $BDClass->columna($BD,$curtemp,0);

       // Apellido del usuario

       if ($Empleado != ''){  
           $cons = "SELECT EMP_Apellido,EMP_Ubicacion FROM Empleados where EMP_ID=$Empleado";
           $BDClass->SQL_CONSULTA($BD,$cons,$curtemp);
           $EmpApe         = $BDClass->columna($BD,$curtemp,0);
           $Ubicacion      = $BDClass->columna($BD,$curtemp,1);
           if ($Ubicacion == ''){
              $Ubicacion ='.';
           }
       }else{
            $EmpApe ='_____';
            $Ubicacion = '.';
       }
       // Permiso para modificar el usuario

       $tieneModif = $HTMLClass->RegValeLine($BD,$GruposModif,$BDClass,$curtemp,$Usuario,$Grupo);

       // Apellido del tecnico
 
       $cons = "SELECT Usr_Apellido FROM Usuarios where USR_ID=$Usuario";
       $BDClass->SQL_CONSULTA($BD,$cons,$cursuser);
       $userape         = $BDClass->columna($BD,$cursuser,0);
       if ($userape ==''){
          $userape="____";
       }  
       // Permiso para cambiar una asignacion
     
       $cambiarASIG = $HTMLClass->RegValeGrp($BD,$GruposAsig,$BDClass,$curtemp,$Usuario,$IDgrpprim);

      //******************************************************************************************

      if ($NroReclamo !=''){
         echo "  <TR> \n";
         echo "     <td class=\"datos\" width=\"8%\" height=\"17\"> \n";
         echo "       <font face=\"arial\" size=1><a href=\"ShowRec.php\">$NroReclamo </a></font></td>\n";

         if (($tienePRIO == "T") || ($ESadmin == "T")){        
            echo "  <td class=\"datos\" width=\"7%\" height=\"17\" align=\"center\"> \n";
            echo "    <a href=\"ReclamosOPER.php?OPER=MOD\"> <img alt=\"Modifica un reclamo\" src=\"$imagen\" border=0 width=\"17\" height=\"17\"></a></td>\n";
         }else{
              echo " <td class=\"datos\" width=\"7%\" height=\"17\" align=\"center\"> \n";
              echo "    <img alt=\"Prioridad del Reclamo.\" src=\"$imagen\" border=0 width=\"17\" height=\"17\"></td>\n";
         }

         echo " <td class=\"datos\" width=\"17%\" height=\"17\">\n";
         echo " <font class = \"hora\" color=#FFFFFF>$Fecha</font>\n";

         if ($tieneModif == "T"){
            echo " <a href=\"CerrarUnReclamo.php?NRO=$NroReclamo\"><img alt=\"Cerrar este llamado\" src=\"http://$servidor/Helpdesk/Reclamos/images/openstatus.gif\" border=\"0\"></a></td>\n";
         }else{
              echo "   <a><img alt=\"Cerrar este llamado\" src=\"http://$servidor/Helpdesk/Reclamos/images/openstatus.gif\" border=\"0\"></a></td>\n";
         }

         echo " <td class=\"datos\" width=\"20%\" height=\"17\">\n";
         echo "  <font face=\"arial\" color=#ffff00 size=1><a href=\"ShowRec.php\">$NTitulo</a></font></td>\n";
 
         if (($tieneModif == "T") || ($ESadmin == "T")){                
            echo " <td class=\"datos\" align=middle width=\"8%\" height=\"17\">\n";
            echo " <font face=\"arial\" color=#ffff00 size=1><a class=\"texto\" href=\"ShowEmp.php?USER=$EmpApe&ORDEN=Rec_NroRef&VISTA=$vista&NROREF=$NroReclamo\">$EmpApe</a></font></td>\n";
         }else{
              echo "  <td class=\"datos\" align=middle width=\"8%\" height=\"17\"> \n";
              echo "  <font face=\"ms sans serif,verdana,arial,helvetica\" color=#ffff00 size=1>$EmpApe</font></td>\n";
         }

         echo " <td class=\"datos\" align=middle width=\"10%\" height=\"17\"> \n";
         echo " <font face=\"ms sans serif,verdana,arial,helvetica\" color=#ffff00 size=1>$Ubicacion</font></td>\n";

         if (($cambiarASIG == "T") || ($ESadmin == "T")){
             echo " <td class=\"datos\" width=\"8%\" height=\"17\"> \n";
             echo " <font color=#ffff00 size=1><a class=\"texto\" href=\"ShowRec.php\">$userape</a></font></td>\n";
         
         }else{
               echo " <td class=\"datos\" width=\"8%\" height=\"17\"><font color=#ffff00 size=1>$userape</font></td>\n";
         }
         echo "</TR>\n";
   
       } // IF NRO reclamo

    $cont++;
    $result = array();
  } // while
 

  echo "    </TABLE>\n";
  echo "   </TD>\n";
  echo "  </TABLE>\n";
  echo " </TABLE>\n";
  echo "</CENTER>\n";
  echo "</BODY>\n";
  echo "</HTML>\n";
  if ($connection !=''){
      $BDClass->Cerrar($BD,$listacursor);
      $BDClass->Cerrar($BD,$cursor);
      $BDClass->Cerrar($BD,$cursuser);
      $BDClass->Cerrar($BD,$curgrp);
      $BDClass->Cerrar($BD,$curtemp);
      $BDClass->desconectarse($BD,$connection);
 
  }
}
0
 
LVL 5

Expert Comment

by:andriv
ID: 6918815
Wow, you have a lot going on. No problem a couple questions:

1) You say it's after 5 or 6 queries, are they one right after the other?

2) Is it a specific query or is it happening to all queries?

3) Are you getting a db error? Do you know if the query is being made before it stops?

4) What db are you using?
0
 
LVL 1

Author Comment

by:Pampa
ID: 6918895
I know read the code is very hard but,

1) Inside Reclamos function I'am using 5 cursors No one give me any error.
2) The error always happened "after" the same query.

$BDClass->SQL_CONSULTA($BD,$consulta,$listacursor);
array($result);
while ($result = $BDClass->Obtengo_linea($BD,$listacursor)){
print every line of $result inside HTML table...

Also had links which make the RECURSION. I mean
I sort the result following a parameter, if I click any of the links I call the first PHP again with the adecuate SORT parameter.
This PHP call this function again.....

The table stop being generate HERE after I click 4 or 5 times the different links.....

}

I though it could be an error outside the loop because I have to rewrite the query depending of the SORT parameter.
 
consulta = $consulta . " ) ORDER by (SELECT COMUN_TEXTO FROM Comunes where COMUN_ID
=REC_COMUN_ID)";

3)the query is made before stop, I don't get any error
4) I'am using ORACLE
0
 
LVL 5

Expert Comment

by:andriv
ID: 6919068
We are going to have to take a step at a time to figure out where the error is accurring.

1) First thing is to make sure that when executing the Queries that the pointer is not pointing to a file after the last record (especially if you are using loop). You want to make sure that you are testing to see if there are any more records before executing the query.

1) then run the script 5 times till it stops, then hit the browser back button and check the <a href="... that you clicked, make sure that the query string is the way it suppose to be and the values are set properly.

2) Since you are calling the script from a link, if you have any special characters you should use the urlencode() functions, for example:

USER=" . urlencode($EmpApe) . "&ORDEN=Rec_NroRef&VISTA=" . urlencode($Vista) . "...

3) If all fails then use a echo statement and see if it prints up to a certain point after 5 executions (when the script stops, if it does move further down until it doesn't display anymore.  This will help you find the exact spot of the problem. Example:

echo "Todos esta bein";

$BDClass->SQL_CONSULTA($BD,$consulta,$listacursor);
array($result);
while ($result = $BDClass->Obtengo_linea($BD,$listacursor)){

If it prints when the error occurs then move further down.



$BDClass->SQL_CONSULTA($BD,$consulta,$listacursor);
array($result);
while ($result = $BDClass->Obtengo_linea($BD,$listacursor)){
echo "Todos esta bein";

Then continue this until you find exactly where the problem starts happening.

0
 
LVL 1

Author Comment

by:Pampa
ID: 6920623
The echo didn't gave me the solution because the loop stop in different places....

I go back with the link, but it's all correct, "NOT null pointers or NULL values".

Thnaks anyway, I will keep on trying
0
 
LVL 1

Author Comment

by:Pampa
ID: 6920672
I think I have another idea of what could happen.

If the query returns more than 8 rows I have the problem, if it`s 8 or less I can't reproduce the error.

I don't have any quota (8).
Any ideas about memory, buffers,etc.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 5

Accepted Solution

by:
andriv earned 200 total points
ID: 6921055
I don't think the buffer but you can use the flush() function to flush the content in the buffer after the tables. (but if the script stops executing before the data gets to the table then this shouldn't do any good)

Memory sounds like a more possible problem. I don't know what you are using as for database functions but if you are using the odbc_ function you can clear the memory after you store the results to variables or at end of script with:

odbc_free_result($dbconnect);

However, the memory should automatically clear as soon as the script completes execution.

I do not beleive Oracle has such a function.

How are you looping to get the next group of records?

while(what condition are you using)
{
get next 10;
}

or

for($i = 0; $i< 10; $i++)
{
get next record;
}

Also, are you using any db function to return an error from the data base with the query?

Example:

if(!(ora_exec($Query,)) //don't remember the exace ora function
{
echo ora_error();
}

or the one for odbc if you are using odbc functions
0
 
LVL 1

Author Comment

by:Pampa
ID: 6921074
$cons = SELECT REC_NroRef,REC_ESTADO,REC_GRP_ID
FROM (SELECT REC_NroRef,REC_ESTADO,REC_GRP_ID,rownum rr
      FROM Reclamos)
where (REC_ESTADO LIKE 'SR' )  AND (REC_GRP_ID =4) AND (rr > $indice AND rr <= $indice)
ORDER by REC_NroRef

while ($result = $BDClass->GET_LINE($BD,$cursor)){
       $NroReclamo  = chop($result[0]);
       echo $NroReclamo;
}
0
 
LVL 5

Expert Comment

by:andriv
ID: 6921135
Yeah, that should not cause a problem.

What makes this problem hard is we do not really know where it's failing. If we had an approximate area we can determine if the error is being caused by the database, query or script but you say it happens at different parts of the script.

Using the method I recommended with echo "todos esta bein" try to find out up to what point never is the error. In other words lets figure out how far the script that does not seem to ever fail.

Also, after you get the fail, view the source on the browser to see if any of the html was sent, we maybe able to figure out where it's failing if it consistanly prints some of the html.
0
 
LVL 1

Author Comment

by:Pampa
ID: 6921182
$cons = SELECT REC_NroRef,REC_ESTADO,REC_GRP_ID
FROM (SELECT REC_NroRef,REC_ESTADO,REC_GRP_ID,rownum rr
      FROM Reclamos)
where (REC_ESTADO LIKE 'SR' )  AND (REC_GRP_ID =4) AND (rr > $indice AND rr <= $indice)
ORDER by REC_NroRef

while ($result = $BDClass->GET_LINE($BD,$cursor)){
       $NroReclamo  = chop($result[0]);
       echo $NroReclamo;
}
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 6928877
Hello.

You have not updated your other open items since my request to you of last month, please do.

ADMINISTRATION WILL BE CONTACTING YOU SHORTLY.  Moderators Computer101 or Netminder will return to finalize these if still open in seven days.  Please post closing recommendations before that time.

Question(s) below appears to have been abandoned. Your options are:
 
1. Accept a Comment As Answer (use the button next to the Expert's name).
2. Close the question if the information was not useful to you, but may help others. You must tell the participants why you wish to do this, and allow for Expert response.  This choice will include a refund to you, and will move this question to our PAQ (Previously Asked Question) database.  If you found information outside this question thread, please add it.
3. Ask Community Support to help split points between participating experts, or just comment here with details and we'll respond with the process.
4. Delete the question (if it has no potential value for others).
   --> Post comments for expert of your intention to delete and why
   --> YOU CANNOT DELETE A QUESTION with comments; special handling by a Moderator is required.

For special handling needs, please post a zero point question in the link below and include the URL (question QID/link) that it regards with details.
http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
 
Please click the Help Desk link on the left for Member Guidelines, Member Agreement and the Question/Answer process for further information, if needed.  http://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp

Click you Member Profile to view your question history and keep them all current with updates as the collaboration effort continues, to track all your open and locked questions at this site.  If you are an EE KnowledgePro user, use the Power Search option to find them.  Anytime you have questions which are LOCKED with a Proposed Answer but does not serve your needs, please reject it and add comments as to why.  In addition, when you do grade the question, if the grade is less than an A, please add a comment as to why.  This helps all involved, as well as future persons who may access this item in the future to seek help.

To view your open questions, please click the following link(s) and keep them all current with updates.
http://www.experts-exchange.com/questions/Q.20159248.html
http://www.experts-exchange.com/questions/Q.20085044.html
http://www.experts-exchange.com/questions/Q.20284876.html




**** PLEASE DO NOT AWARD THE POINTS TO ME. *****
 
------------>  EXPERTS:  Please leave your closing recommendations if this item remains inactive another seven (7) days.  If you are interested in the cleanup effort, please click this link http://www.experts-exchange.com/jsp/qManageQuestion.jsp?ta=commspt&qid=20274643
POINTS FOR EXPERTS awaiting comments are listed here -> http://www.experts-exchange.com/commspt/Q.20277028.html
 

Moderators will finalize this question if still open in 7 days, by either moving this to the PAQ (Previously Asked Questions) at zero points, deleting it or awarding expert(s) when recommendations are made, or an independent determination can be made.  Expert input is always appreciated to determine the fair outcome.
 
Thank you everyone.
 
Moondancer
Moderator @ Experts Exchange
0
 
LVL 5

Expert Comment

by:andriv
ID: 6928902
Pampa,

were you able to get it working?
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7116312
Zero response, finalized.
Moondancer - EE Moderator
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
htacces issue 2 39
XSS cleaning when using ajax & json encode 5 38
windows 10 bash shell 4 35
Change password through link 1 7
Deprecated and Headed for the Dustbin By now, you have probably heard that some PHP features, while convenient, can also cause PHP security problems.  This article discusses one of those, called register_globals.  It is a thing you do not want.  …
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now