> -----Original Message-----
> From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 07, 2002 10:50 AM
> To: CF-Talk
> Subject: FoxPro General Error
>
>
> Any FoxPro folks out there that can tell me why I am receiving this
error?
Unless I'm reading it wrong, you have one more "(" than you have ")".
> ODBC Error Code = S1000 (General error)
>
>
> [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).
>
> I am not sure what function is missing. This query works fine in
> Access and
> SQL Server.
>
> SQL = "SELECT DISTINCT drname.DR_ID, drname.DR_LNAME,
drname.DR_FNAME, dr
> name.DR_INAME FROM (drname LEFT JOIN stfstatu ON drname.DR_ID =
stfstatu.
> DR_ID) RIGHT JOIN Address ON drname.DR_ID = Address.DR_ID WHERE
(((drname
> DR_LNAME) Like 'N%') AND ((stfstatu.DR_ID)=[drname].[dr_id]) AND
((stfst
> atu.ACTIVE123)='1') AND ((Address.SCH_TYPE)='1')) OR
(((Address.OVERRID
> E)='1')) ORDER BY drname.DR_LNAME
> Thanks,
> Bruce
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
