The query you are running is for MS SQL not Access, there is a similiar query for access, you might want to look it up in the Access reference or use google..
----- Original Message ----- From: "Rebecca Joy Sherman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 7:50 AM Subject: ERROR - GET TABLES IN DATASOURCE / GET FIELDS IN TABLE > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
