GETTING ERROR:
Error Diagnostic InformationODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. <cfquery datasource="#application.db#" name="getstuff"> 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 </cfquery> 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
