I'm running CF5 connecting to a PostgreSQL db. I've noticed
when using a <cfquery> that the column names will be converted
to lowercase when sending a query to the db, which cause an error.
So far my only solution has been to make all column names lowercase
in my db schema. (which is driving me nuts)
Here's an example:
The table:
CREATE TABLE "test1" (
"MixedCase" text
);
The query:
<cfquery name="testCase" datasource="pgtest">
SELECT MixedCase
FROM test1
</cfquery>
And the error:
Error Diagnostic Information
ODBC Error Code = 00000 ()
Error while executing the query (non-fatal); ERROR: Attribute 'mixedcase'
not found
SQL = "SELECT MixedCase FROM test1"
Data Source = "PGTEST"
I'm using pgAdminII as a front end to PGSQL, and I realize that
when creating tables, that pgadminII will make the column names
literal, as shown above, but my queries are following the case
of the schema, so I suspect the problem is in the unixODBC driver.
Can anyone confirm this? Work-arounds or fixes?
TIA,
Dave Vause
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
