JDBC Driver problem with MS SQL Server 2000

2003-07-28 Thread Don
(@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, 2003 8:21 PM To: CF-Talk Subject: JDBC Driver problem with MS SQL

JDBC Driver problem with MS SQL Server 2000

2003-07-27 Thread LI, Chunshen \(Don\)
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

RE: JDBC Driver problem with MS SQL Server 2000

2003-07-27 Thread Joe Eugene
(@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, 2003 8:21 PM To: CF-Talk Subject: JDBC Driver problem with MS SQL