php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #50623 odbc_field_name
Submitted: 2009-12-31 14:42 UTC Modified: 2015-04-11 14:40 UTC
Votes:3
Avg. Score:4.7 ± 0.5
Reproduced:3 of 3 (100.0%)
Same Version:2 (66.7%)
Same OS:2 (66.7%)
From: bpelletier at alct dot ca Assigned: cmb (profile)
Status: Closed Package: ODBC related
PHP Version: 5.3.1 OS: Windows XP Pro
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: bpelletier at alct dot ca
New email:
PHP Version: OS:

 

 [2009-12-31 14:42 UTC] 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

...............

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2010-04-16 20:02 UTC] rony_tobins at hotmail dot com
why not bump up char name[32]; to char name[256]; in php_odbc_includes.h?
 [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
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


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Apr 26 20:01:29 2024 UTC