Wow, that did it.
I thought I had tried every combination of brackets, prens, quotes and
double quotes.
Thanks, this is the first time I've used a join so I wasn't really sure
Access supported it or even if that exactly what I wanted (It is).
Another strange thing if I change OLE DB connection (thought that might
help). I get an even more cryptic error. I'll go back and apply your
bracketing convention now and see if I can get it to work with the OLE DB.
Thanks Again
Doug Kronenberger
OI National Training and Education Office
Department of Veterans Affairs
440-526-3030 x7776
[EMAIL PROTECTED]
-----Original Message-----
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 8:57 AM
To: CF-Talk
Subject: RE: MS Access JOIN Error
Does this work?
FROM [MPA log] LEFT JOIN [52 log]
ON [MPA log].[MPA #] = [52 log].[MPA #]
Those table names and field names are pretty confusing.
Is it an option for you to change the names so that they
do not contain spaces, pound signs etc?
Nick
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 3:37 PM
To: CF-Talk
Subject: MS Access JOIN Error
I'm getting the following error when trying to do a left join from an Access
database from CF. I really don't know what I'm doing. Any clues would be
appreciated
Error Diagnostic Information ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Join expression not
supported.
SQL =
"SELECT "MPA Log.Service/FCP/T&L" AS Service, "MPA Log.MPA #" AS
MPAnumb, "MPA Log.Position Title" AS PositionTitle, "MPA Log.Series", "MPA
Log.Grade", "MPA Log.MPA Posted" AS Open, "MPA Log.Closing Date" AS Close,
"MPA Log.Panel Reuired" AS Panel, "MPA Log.Cert Issued" AS Cert, "MPA
Log.Status/Comment" AS Comment, "52 log.Supervisor" AS Supervisor
FROM "MPA log" LEFT JOIN "52 log"
ON 'MPA log.MPA #' = '52 log.MPA #'"
Data Source = "HRTRACKER" The error occurred while processing an
element with a general identifier of (CFQUERY), occupying document position
(3:1) to (4:32). Date/Time: 05/09/01 10:06:18 Browser: Mozilla/4.0
(compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 10.3.193.44
Thanks in Advance
> Doug Kronenberger
> OI National Training and Education Office
> Depatment of Veterans Affairs
>
> 440-526-3030 x7776
[EMAIL PROTECTED]
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
