Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002091

[PHP-DB] pg_query creates wrong query From: Sascha Alexander Jopen (jopen <email protected>)
Date: 09/04/02

Hi there,

I'm new to PHP, especially to the db-functions.
I've got a problem querying my PostgreSQL server using pg_query.
The Tables i'm working on contain colume names with uppercase letters.
Working on those tables directly with psql, the client program delivered
with postgresql, works like expected. Its case-sensitive, so you have to
specify the table names with the correct case of the letters. But pg_query
seems to convert all queries into lowercase.

A query like: INSERT INTO users (UsrLoginName, UsrPassword) VALUES ...
results in an errormessage like: PHP Warning: pg_query() query failed:
ERROR: Relation 'users' does not have attribute 'usrloginname' ...

What did i do wrong? Or is it a problem with the postgresql db-package of
PHP?

I think, if the backend is case-sensitive, PHP's functions should be
case-sensitiv, too!
Please don't tell me to convert all tables/colums to lowercase!

My config:
Apache 2.0.40 + PHP 4.2.2 + PostgreSQL 7.2.2

Thanks in advance,
Sascha 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php