...

View Full Version : column names appears trimmed



shaileshpatil
03-05-2009, 12:36 PM
Hi experts

I have a problem retireving columns from MSSQL database. Column names appear trimmed in array..
I am using pear DB on windows.

for eg.


$sql="Exec dbo.up_parmsel_projects ";
$arr=$db->getAll($sql,DB_FETCHMODE_ASSOC);

Array ( [Project_ID] => 1234 [CertificateCrLfsAfterAnnexIntr] => 1 [CertificateCrLfsAfterProducts_] => 10 )
see the columns "CertificateCrLfsAfterAnnexIntr" and "CertificateCrLfsAfterProducts_" these are incomplete names. On linux it works perfectly fine, without any problems.

What could be the cause and solution for this wierd problem

shaileshpatil
03-06-2009, 05:12 AM
Hi Guys.

Any clue what going wrong.
Is it for my php settings or pear db?

Thanks in advance.

shaileshpatil
03-09-2009, 06:14 AM
Hello Experts

Any ideas?

achcore
03-09-2009, 07:21 AM
Is your stored procedure running fine without pear? Check that first. If that is done then you have got some problem in PEAR. Bu i think you have a problem with your stored procedure.

shaileshpatil
03-09-2009, 10:17 AM
thanks for reply.
My stored procedure runs perfectly fine.
I have same project up and running on linux server. Over there everything works fine. It only happened when i moved it to my windows computer.
So, i guess its a problem with Pear DB on windows box.
Are there any workarounds for the same?



Is your stored procedure running fine without pear? Check that first. If that is done then you have got some problem in PEAR. Bu i think you have a problem with your stored procedure.

achcore
03-09-2009, 11:42 AM
I mean to say, is your stored procedure running successfully in windows computer without the PEAR?

shaileshpatil
03-10-2009, 06:34 AM
Yes. it does. without any problem.
And as i said, i successfully done this on Linux. And MSSQL server is same for both the environment.


I mean to say, is your stored procedure running successfully in windows computer without the PEAR?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum