Thanks Jeff! ;-)
Yves On 11/6/05, Jeff Garza <[EMAIL PROTECTED]> wrote: > you need to alias your fields... > > SELECT [first name] AS fname FROM mytable > > You'll have to do this for any column that contains spaces... > > HTH, > > Jeff > > ----- Original Message ----- > From: "Yves Arsenault" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > Sent: Sunday, November 06, 2005 6:06 PM > Subject: Problem with fields in SQL 2000 DB > > > > Hello, > > > > I was given a small contract to build a front end for a MS SQL 2000 DB. > > > > The server used to build the front end is currently using BD as the cfml > > server. > > > > I was into the process of starting to code and I noticed something > > that is giving me a bit of a problem. > > > > 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? > > > > Thanks, > > > > -- > > Yves Arsenault > > > > "This year, or this month, or, more likely, this very day, we have > > failed to practise ourselves the kind of behaviour we expect from > > other people." > > C.S. Lewis > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223393 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
