CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Table names w/spaces not accepted with CC

Print topic Send  topic

Author Message
spaceclown
Posted: 05/24/2002, 8:22 AM

I have numerous tables with space in their names like "First Name". Is their a way to make them work with CC so I don't have to rewrite my whole site? And just for curiosity why doesnt CC let you have spaces in table names?
Ken Hardwick
Posted: 05/24/2002, 9:41 AM

Here are a couple of suggestions you might try...

1) In custom SQL...do something like..

Select * from [First Name]

2) In your database, create a query for each of your tables with
spaces and name the query such as there are no spaces..then use the
query instead of the table in CC

Query = Select * from [First Name]
Query Name = "First_Name"



   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.