JDBC Driver problem with MS SQL Server 2000

@sqlStmt) > >You might also want to look into "sp_executesql". >Your problem really might be some casting/invalid quotes. > >Joe Eugene > > >> -Original Message- >> From: LI, Chunshen (Don) [mailto:[EMAIL PROTECTED] >> Sent: Sunday, July 27,

RE: JDBC Driver problem with MS SQL Server 2000

ugene > -Original Message- > From: LI, Chunshen (Don) [mailto:[EMAIL PROTECTED] > Sent: Sunday, July 27, 2003 8:21 PM > To: CF-Talk > Subject: JDBC Driver problem with MS SQL Server 2000 > > > My environment, CFMX Prof, Windows XP Pro OS, MS SQL > Server 2000 D

JDBC Driver problem with MS SQL Server 2000

My environment, CFMX Prof, Windows XP Pro OS, MS SQL Server 2000 DB server. The following query executes fine with Query Analyzer and the query execution shows up fine by CF debugging, however, I got the following annoying err msg, please note, I must use column alias for referencing later, and if