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

Mon, 20 Mar 2006 23:27:17 -0800

 
Yep, that would achieve the same as my query, but the problem still exists with getting the value out at the other end. Which should be solved by referring to it as #qContacts["First name"]#
 
seeya
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear
Sent: Tuesday, 21 March 2006 6:22 PM
To: [email protected]
Subject: [cfaussie] Re: DB field with a space in it

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 [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---

Reply via email to