(@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
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
(@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
3 matches
Mail list logo