Home Articles FAQs XREF Games Software Instant Books BBS About FOLDOC RFCs Feedback Sitemap
irt.Org

Feedback on: irt.org FAQ Knowledge Base Q3006, May 04, 2000 at 11:48:28:

You are here: 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

©2018 Martin Webb