|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2010-04-16 20:02 UTC] rony_tobins at hotmail dot com
[2015-04-11 14:40 UTC] cmb@php.net
-Status: Open
+Status: Closed
-Assigned To:
+Assigned To: cmb
[2015-04-11 14:40 UTC] cmb@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Nov 06 14:00:01 2025 UTC |
Description: ------------ I use odbc_connect to connect to my sql server 2005. When I want a column where the field name longer than 31 characters, odbc_result cuts the name to 31 characters. I really need to know how to overrite the struct to have the possibilities to have at least 64 characters. Thanks for you help. I see many bugs reporting the same but no solution are proposes. Reproduce code: --------------- $requete= "SELECT * FROM Usagers WHERE NomUsager = '" . $p_nomUsager . "';"; $resultat= ExecuterRequete($requete); ProchainEnregistrement($resultat); for ($i=1; $i < odbc_num_fields($resultat) + 1; $i++) echo odbc_field_name($resultat, $i)." - "; function ExecuterRequete($p_requete) { return odbc_exec($_SESSION['BDConnection'], $p_requete); } function ProchainEnregistrement($p_resultat) { return odbc_fetch_row($p_resultat); } Expected result: ---------------- I want the full name of the fields. Actual result: -------------- NomUsager - NoEmployeALCT - UsagerActif - DerniereLangueUtiliseUsager - MotDePasseUsager - AccesProgrammeGestionALCT - AccesProgrammeInternational - AccesProgrammeFacturation - AccesGestionALCTConsulterEmploy - AccesGestionALCTAjouterEmploye - AccesGestionALCTModifierEmploye - AccesGestionALCTSupprimerEmploy - AccesGestionALCTConsulterRappor - AccesInternationalConsulterClie - AccesInternationalAjouterClient - AccesInternationalModifierClien - AccesInternationalSupprimerClie - AccesInternationalConsulterCont - AccesInternationalAjouterContac - AccesInternationalModifierConta - AccesInternationalSupprimerCont - AccesInternationalConsulterProd - AccesInternationalAjouterProdui - AccesInternationalModifierProdu - AccesInternationalSupprimerProd - AccesInternationalConsulterCour - AccesInternationalAjouterCourti - AccesInternationalModifierCourt - AccesInternationalSupprimerCour - AccesInternationalConsulterComp - AccesInternationalAjouterCompte - AccesInternationalModifierCompt - AccesInternationalSupprimerComp - AccesInternationalConsulterTran - AccesInternationalAjouterTransp - AccesInternationalModifierTrans - AccesInternationalSupprimerTran - AccesInternationalConsulterCont - AccesInternationalAjouterContac - AccesInternationalModifierConta - AccesInternationalSupprimerCont - AccesInternationalConsulterProv - AccesInternationalAjouterProvin - AccesInternationalModifierProvi - AccesInternationalSupprimerProv - AccesInternationalConsulterRapp - AccesInternationalConsulterSoum - AccesInternationalAjouterSoumis - AccesInternationalModifierSoumi - AccesInternationalSupprimerSoum - AccesInternationalConsulterDema - AccesInternationalAjouterDemand - AccesInternationalModifierDeman - AccesInternationalSupprimerDema - AccesInternationalReviserDemand - AccesConfiguration - UsagerAjoutPar - UsagerDateAjout - UsagerDerniereMiseAJourPar - UsagerDerniereMiseAJour - Warning: odbc_result() [function.odbc-result]: Field AccesGestionALCTSupprimerEmploye not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79 Warning: odbc_result() [function.odbc-result]: Field AccesGestionALCTConsulterEmploye not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79 Warning: odbc_result() [function.odbc-result]: Field AccesGestionALCTConsulterRapport not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79 Warning: odbc_result() [function.odbc-result]: Field AccesInternationalModifierClient not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79 Warning: odbc_result() [function.odbc-result]: Field AccesInternationalSupprimerClient not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79 Warning: odbc_result() [function.odbc-result]: Field AccesInternationalConsulterClient not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79 Warning: odbc_result() [function.odbc-result]: Field AccesInternationalAjouterContactClient not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79 ...............