Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hsilveira

    Warning: odbc_fetch_array(): 7 is not a valid ODBC result resource...

    Thank you all. Done. I'm using SQL Server 2005 so i create another ODBC connection and it worked. thank's a lot ingresman. Regards
  2. hsilveira

    Warning: odbc_fetch_array(): 7 is not a valid ODBC result resource...

    That's it... i have a query and then in that loop i call RetrieveStatus which also issues a select. How can i workaround this problem? Thanks in advance
  3. hsilveira

    Warning: odbc_fetch_array(): 7 is not a valid ODBC result resource...

    I do a simple test that is create a new php test file with this code that uses my function RetrieveStatus: <?php require("information.php"); //this file has DB Info require("Methods/GlobalFunctions.php"); //This file has Retrieve Status function echo(RetrieveStatus($db, $user, $pass, '1')); ?>...
  4. hsilveira

    Warning: odbc_fetch_array(): 7 is not a valid ODBC result resource...

    Do you get anything else when you add the "or die(odbc_errormsg());" Nothing else was shown on the screen Or just echo it by itself after having executed the query?: echo odbc_errormsg(); returns no data
  5. hsilveira

    Warning: odbc_fetch_array(): 7 is not a valid ODBC result resource...

    I think the limitation exist when we use the odbc_fetch_array. I follow your suggestion but the error persists. On the other hand, the function returns the correct result and put it in the screen. The problem is the warning that is also displayed. If i don't call my function, php returns 1...
  6. hsilveira

    Warning: odbc_fetch_array(): 7 is not a valid ODBC result resource...

    Hi vacunita, I thing the error happens because i can't call a functions inside the "while($registo=odbc_fetch_array($resultado)) ". This is the line nº 184. **** function RetrieveStatus($db, $user, $pass, $Status) { $ligacao = odbc_connect("$db", "$user", "$pass"); $comando_sql =...
  7. hsilveira

    Warning: odbc_fetch_array(): 7 is not a valid ODBC result resource...

    Hi all, I have a problem and i don't know how to solve it. I'm using odbc_fecth_array to retrieve some data from my database. (See below) while($registo=odbc_fetch_array($resultado)) { $CreatedBy = $registo["CreatedBy"]; $CreationDate = retrieve_data_DB($registo["CreationDate"]); $AssignTo...

Part and Inventory Search

Back
Top