<!--- First go to Tools -> Options -> click on Hidden Objects and System Objects, then go back to Tools -> Security -> User and Group permissions -> highlight the MSSysObjects table and then check the Read Data check box, then click OK.. --->
<cfquery datasource="#dsn#" name="GetTables"> SELECT name FROM MSysObjects WHERE TYPE=1 and left(MSysObjects.name,4) <> 'MSys' </cfquery> <cfoutput query="GetTables"> Table: #name#<br> <cfquery datasource="#dsn#" maxrows="1" name="fields"> SELECT * FROM #getTables.name# </cfquery> Fields: #fields.columnList#<br> </cfoutput> Please turn off the caps lock key :) -- jon mailto:[EMAIL PROTECTED] Tuesday, February 4, 2003, 4:50:54 PM, you wrote: RJS> GETTING ERROR: RJS> Error Diagnostic InformationODBC Error Code = 37000 (Syntax error or access RJS> violation) [Microsoft][ODBC Microsoft Access Driver] The SELECT statement RJS> includes a reserved word or an argument name that is misspelled or missing, RJS> or the punctuation is incorrect. RJS> <cfquery datasource="#application.db#" name="getstuff"> RJS> SELECT sysobjects.id as tableid,sysobjects.name as tablename, RJS> syscolumns.name as columnname RJS> FROM sysobjects, syscolumns RJS> WHERE sysobjects.type = 'U' RJS> AND sysobjects.id = syscolumns.id RJS> ORDER by sysobjects.id RJS> </cfquery> RJS> At 03:19 PM 2/4/2003 -0400, you wrote: >>SELECT sysobjects.id as tableid,sysobjects.name as tablename, >>syscolumns.name as columnname >>FROM sysobjects, syscolumns >>WHERE sysobjects.type = 'U' >>AND sysobjects.id = syscolumns.id >>ORDER by sysobjects.id RJS> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
