haha That's the first thing I thought of....
I had tried the alias, but didn't use quotes. I'll use the quotes and try to have fun with this... Thanks, Yves On 11/6/05, Dave Watts <[EMAIL PROTECTED]> wrote: > > I noticed that some of the table's field names are named with > > spaces.. like: "First name" > > > > So when I query this and dump the query, I see all the info.. > > > > When I try a cfoutput the First name field I get a Badly formatted > > template error.... > > > > I'm assuming that the space in the field name is going to be > > troublesome. > > > > Ideas? > > First, you should find the guy who created the database, and beat him > soundly over the head with the SQL Server book of your choice. > > Then, within your SQL, alias those columns: > > SELECT "First Name" AS First_Name, ... > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223392 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
