I don't know if this will help any but you have
missing and mis matched quotes.
"52 log.Supervisor" AS Supervisor, i suppose
Supervisor should have double quotes around it as you
have with the previous variables!
FROM "MPA log" LEFT JOIN "52 log" ON 'MPA log.MPA #' =
'52 log.MPA #'" what's this last double quote for?!
Heidi
--- [EMAIL PROTECTED] wrote:
> 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]
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
