Ok fellow CF developers, using CFMX 6.1 riddle me this�
Why does the SQLServer JDBC Driver spit the dummy with the following
query:
<cfquery name="qInsertSandpit"
datasource="DB_Native">
SET NOCOUNT ON
INSERT INTO Sandpits
(Name)
VALUES
('My Sandpit Name')
SET NOCOUNT OFF
SELECT @@IDENTITY AS �Sandpit_ID�
</cfquery>
Yet if you use an ODBC Socket connection, i.e:
<cfquery name="qInsertSandpit"
datasource="DB_ODBC">
SET NOCOUNT ON
INSERT INTO Sandpits
(Name)
VALUES
('My Sandpit Name')
SET NOCOUNT OFF
SELECT @@IDENTITY AS �Sandpit_ID�
</cfquery>
It works fine!
I am using SQL Server 200 and CF 6,1,0,83762. The error I get when using
the native db connection is:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 7: Incorrect syntax
near '�'.
Any pointers greatly appreciated,
Malcolm
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
