Hi guys,
I am having serious problem with porting a mysql based application to Postgres.
How do i enable PostGres to read capitalized column names ?
e.g:
Table Name: NetworkTab
This table has two fields named "NetCode" and "NetworkName".
but after fetching * from NetworkTable the values fetched (associative) does not display the results.
i,e if i say
echo $Row["NetCode"] it prints nothing ... where as
echo $Row["netcode"] prints the actual correct value.. where as "NetCode" is the actual column name.
At this stage i cannot modify all the colums names to lower cases, and I am using PEAR DB.
Is there any solution to this problem.
I need a urgent solution,
Thanks in advance,
Danny ..
I am having serious problem with porting a mysql based application to Postgres.
How do i enable PostGres to read capitalized column names ?
e.g:
Table Name: NetworkTab
This table has two fields named "NetCode" and "NetworkName".
but after fetching * from NetworkTable the values fetched (associative) does not display the results.
i,e if i say
echo $Row["NetCode"] it prints nothing ... where as
echo $Row["netcode"] prints the actual correct value.. where as "NetCode" is the actual column name.
At this stage i cannot modify all the colums names to lower cases, and I am using PEAR DB.
Is there any solution to this problem.
I need a urgent solution,
Thanks in advance,
Danny ..