> Using this:
>
> <cfoutput query="get_sweatertype">
> #get_sweatertype.table_schema#, #get_sweatertype.table_name#<br>
> </cfoutput>
>
> Here's a partial output of the list:
> public, Yarn
> public, SweaterType
You have defined case-sensitive table names:
http://www.postgresql.org/docs/current/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
You should be able to query them as using:
<cfquery ...>
SELECT *
FROM "SwaterType"
</cfquery>
But I would recommend dumping your schema, removing the double
quotes and restoring.
Jochem
--
When you don't want to be surprised by the revolution
organize one yourself
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
