In your SQL Select statement reference by using the back ticks and
give it a new name with the AS.
SELECT `6 AM` AS 6AM, ....
As for variables <CFOUTPUT>#6AM#</CFOUTPUT> ... if I remember
correctly is invalid ... CF vars can't begin with a numeric value.
Joe Hoffman mailto:[EMAIL PROTECTED]
National Institutes of Health
Center for Information Technology
Division of Computer System Services
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 11:47 AM
To: [EMAIL PROTECTED]
Subject: Access Field Names with Blanks in them
I am re-writing a scheduling program that was written in ASP/VB to work in
Cold
Fusion. The scheduling program uses an Access Database as its backend.
This is just a small program and we are trying to keep the backend the same
and
just re-write the front end. However, the person that wrote this access
database made the field names contain spaces. For example, one field name
is 6
AM
I didn't think you could have spaces in a field name. But even so, how do
you
tell Cold Fusion the field name? I didn't think you could use #6 AM#.
I have just started re-writing it and I am going to try referencing the
field
name as #6 AM#, but I wanted to get feedback.
Is this the right way to do it? I would like not to have to re-write the
back
end just yet.
Mary
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
