Feedback on: irt.org FAQ Knowledge Base Q3006

irt.org | About | Feedback | 1180 [ previous next ]

Feedback on:
irt.org FAQ Knowledge Base Q3006

Sent by
Orlando Correa on May 04, 2000 at 11:48:28:

Worth:
Very worth reading

Comments:
I wrote the following CF for SQL Server to get all the tables using the system tables:

<CFQUERY NAME="getTables" DATASOURCE="#ds#" DBTYPE="ODBC">
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
<CFIF IsDefined("url.table_name")>
WHERE table_name='#url.table_name#'
<CFELSE>
ORDER BY table_schema, table_name, ordinal_position desc
</CFIF>
</CFQUERY>

Thanks for providing the MS Access version...

Other feedback on 'irt.org FAQ Knowledge Base Q3006' - show all

• irt.org FAQ Knowledge Base Q3006 - THIS EXAMPLE DOES NOT WORK October 16, 2001 at 22:40:34:
• irt.org FAQ Knowledge Base Q3006 - Matt Fisher 22:55:41 9/26/00
• irt.org FAQ Knowledge Base Q3006 - shankar 06:36:13 7/05/00
• irt.org FAQ Knowledge Base Q3006 - Orlando Correa 11:48:28 5/04/00