table & field name case senstive problem
| From: | Vincent Ma | Date: | Wed, 14 Nov 2001 06:36:42 +0000 |
| Subject: | table & field name case senstive problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14314@lists.php.net to get a copy of this message | ||
Hi everyone:
I found the problem when retrieve data from table or field which are
mix-case. I means table or field name like "accommdationType". contain
lower and upper case character.
For example:
Query "select compID from table"
after pg_exec() --> "select compid from table"
Thus, I got error message said "no attribute **compid***". the field or
table become lower case.
Is anyone know how to prevent pg_exec case conversion. I guess may put
some special character around the field name.
Thank for any help
Vincent Ma