you also need to alias the table name to use with CF
SELECT
[6 AM] as toodamnearly
...
and you would ref it in CFOUTPUT as #toodamnearly#
-----Original Message-----
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 12:03 PM
To: [EMAIL PROTECTED]
Subject: Re: Access Field Names with Blanks in them
Use "[ ]" around the table names
~JustinMacCarthy
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 08, 2000 4:46 PM
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.
------------------------------------------------------------------------------
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.
