Doing a read sql with an update odbc connection gives warning !?

PhilippeDJ

I have an odbc connection open for update, when I first read with the connection I get a warning :

Warning: odbc_fetch_row(): 4 is not a valid ODBC result resource in c:\Inetpub\wwwroot\transportlijst\sendMail.php on line 33

I read one file and then do an update with the data in another file and would like to do this with the same connection, I'm not sure why I'm getting the warning.

Houdini

It would help others to help you if you were to post the code that is causing the problem, it could be any number of things and difficult to give you a reasonable answer or solution without some code.

PhilippeDJ

 

////////////////////////////////////////////////////////////////////////////////////////////////////////
// openI5ODBCconnection
////////////////////////////////////////////////////////////////////////////////////////////////////////

function openI5ODBCconnection($open4update = false){

if ($open4update) {
  $conn = openODBCconnection('I5UPD','ODBCuser','ODBCpassword');
}
else {
$conn = openODBCconnection('I5','ODBCuser','ODBCpassword');
}

return($conn);

}

////////////////////////////////////////////////////////////////////////////////////////////////////////
// executeUpdateSQL
////////////////////////////////////////////////////////////////////////////////////////////////////////

function executeUpdateSQL($conn, $sql){

  $rs = odbc_exec($conn,$sql);

  if (applicationInTestMode()) {
    writeSQL2LogFile($sql);
  }

  if (!$rs)
  {
    exit("Error in sql " . $sql);
  }

}

////////////////////////////////////////////////////////////////////////////////////////////////////////
// executeReadSQL
////////////////////////////////////////////////////////////////////////////////////////////////////////

function executeReadSQL($conn, $sql){

  $rs = odbc_exec($conn,$sql);

  if (applicationInTestMode()) {
    writeSQL2LogFile($sql);
  }

  if (!$rs)
  {
    exit("Error in sql " . $sql);
  }

  return($rs);

}

////////////////////////////////////////////////////////////////////////////////////////////////////////
// closeODBCconnection
////////////////////////////////////////////////////////////////////////////////////////////////////////

function closeODBCconnection($conn){

odbc_close($conn);

}


$sql = "select * from $lib.trlydp where tddlgx = " . $dlgx . " and tdrexr = " . $route . " order by tdnrsq";

$conn = openI5ODBCconnection(true);
$rs = executeReadSQL($conn,$sql);

while (odbc_fetch_row($rs)){
  $tdrseq = odbc_result($rs,"tdrseq");
  $tdnrsq = odbc_result($rs,"tdnrsq");
  $tdklnr = odbc_result($rs,"tdklnr");
  $nieuweSequentie = $route . addleadingZeros($tdnrsq,4);
  $veld = "opmChauffeur" . addleadingZeros($tdrseq,7);
  $extraOpmerkingen = " " . $_REQUEST[$veld];

  $lib = getLib("dbd001lib");
  $sql = "update $lib.wer0001 set rseqe1 = " . $nieuweSequentie . ", opm3e1 = trim(opm3e1) concat '" . $extraOpmerkingen. "' where rseqe1 = " . $tdrseq . " and kklge1 = '" . $tdklnr . "'";
  executeUpdateSQL($conn,$sql);
}