Byron
|
| Posted: 11/14/2002, 10:43 AM |
|
Hi...
i just download the codecharge trial, i create a database on PostgreSQL, then i generate some pages and try to test it, but i have this error...
--- Error ---
Warning: PostgreSQL query failed: ERROR: Attribute 'cod_persona' not found in /var/www/html/db_pgsql.inc on line 67
Database error: Invalid SQL: SELECT COD_Persona,NUM_Seguridad FROM personas WHERE TXT_Usuario ='test' AND TXT_Contrasena='test'
PostgreSQL Error: 1 (ERROR: Attribute 'cod_persona' not found )
Session halted.
--- Error ---
Can someone help me about this?
Thanks.
|
|
|
 |
Florin
|
| Posted: 11/16/2003, 2:29 AM |
|
PostgreSQL can acces columns that are named using capitalized letters only if they are included in "" (i.e. "ColumnName").
So the correct form of the statement above is:
SELECT "COD_Persona", "NUM_Seguridad" FROM personas WHERE "TXT_Usuario" ='test' AND "TXT_Contrasena"='test'
That's why I prefer using only lowercase when giving names to PostgreSQL db identifiers.
|
|
|
|
|
