Use square brackets around the names like: select [some column] from [some table]
HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm ----- Original Message ----- From: "Kernel Sanders" <[EMAIL PROTECTED]> To: "CF_OpenSource" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 11:11 AM Subject: spaces in database > I have an existing Access database that I would like > to retrieve information from. The database was > designed with spaces for table and column names. Is > there any trick to use the database "as is". I am not > the owner of the Access database but want to have a > read-only display of the data. > > __________________________________________________ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > Archives: http://www.mail-archive.com/[email protected]/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
