[cfaussie] Re: DB field with a space in it

[Mike Kear]

OK let me re-do that based on reading your question properly ...   wouldnt you do this:

 

<CFQUERY name="qContacts">

    SELECT firstName AS  [First Name]

    FROM contacts

</CFQUERY>

Cheers
Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month

 

 

On 3/21/06, Mike Kear <[EMAIL PROTECTED]> wrote:

Doesnt SQLServer allow you to use square brackets too?    If you accidentally put a space in Ent Mgr while you're building tables it'll put square brackets around the name .. for example:

 

SELECT [First name], lastname  from  users

 

Cheers
 

Mike Kear
Windsor, NSW, Australia
Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month

 

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---