>
> What do you get when you run:
> SELECT *
> FROM INFORMATION_SCHEMA.tables
>
> Jochem
It works - was able to get a listing out of a cfoutput query of all the items in this location.
Using this:
<cfoutput query="get_sweatertype">
#get_sweatertype.table_schema#, #get_sweatertype.table_name#<br>
</cfoutput>
Here's a partial output of the list:
pg_catalog, pg_namespace
pg_catalog, pg_conversion
pg_catalog, pg_depend
pg_catalog, pg_attrdef
public, Yarn
public, SweaterType
When I tried this:
<cfquery name="get_SweaterList" datasource="gensweat" username="postgres" password="tester">
SELECT *
FROM public.SweaterType
</cfquery>
<cfoutput query="get_sweaterlist">
#getsweaterlist.type#<br>
</cfoutput>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
