Bug #50623 [Opn->Csd]: odbc_field_name
Edit report at https://bugs.php.net/bug.php?id=50623&edit=1
ID: 50623
Updated by: cmb@php.net
Reported by: bpelletier at alct dot ca
Summary: odbc_field_name
-Status: Open
+Status: Closed
Type: Bug
Package: ODBC related
Operating System: Windows XP Pro
PHP Version: 5.3.1
-Assigned To:
+Assigned To: cmb
Block user comment: N
Private report: N
New Comment:
Thank you for your bug report. This issue has already been fixed
in the latest released version of PHP, which you can download at
http://www.php.net/downloads.php
Previous Comments:
------------------------------------------------------------------------
[2010-04-16 20:02:07] rony_tobins at hotmail dot com
why not bump up char name[32]; to char name[256]; in php_odbc_includes.h?
------------------------------------------------------------------------
[2009-12-31 14:42:09] bpelletier at alct dot ca
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
...............
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=50623&edit=1
Thread (3 messages)