I'd fix the query first and see if it helps ;-)
INSERT INTO #getuser.owner#.djbtest ('id')
VALUES ('sdfasdfafasdfasfd')
You have single quotes around the column name
-----Original Message-----
From: Derek Bezuidenhout [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 03, 2006 10:22 AM
To: CF-Talk
Subject: Re: SQL ''Invalid Object Name'' on Insert, after Create Table
Thanks for the suggestions so far. I'll try them now.
Here's the code:
<cfquery name="createTable" datasource="aaa_bwdatadump">
IF object_id('aaa_bwdatadump..djbtest') IS NOT NULL
BEGIN
DROP TABLE djbtest
END
CREATE TABLE dbo.djbtest (
id varchar(200)
)
</cfquery>
<cfquery name="geta" datasource="aaa_bwdatadump">
SELECT * from djbtest
</cfquery>
<cfdump var="#geta#">
<cfquery name="getuser" datasource="aaa_bwdatadump">
SELECT name, xtype, uid AS [owner id], USER_NAME(uid) AS owner
FROM sysobjects
WHERE name LIKE '%djbtest%'
</cfquery>
<cfdump var="#getUser#">
<cfquery name="InitVals" datasource="aaa_bwdatadump">
INSERT INTO #getuser.owner#.djbtest ('id')
VALUES ('sdfasdfafasdfasfd')
</cfquery>
---------------------------------------------------------
And the error:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name
'dbo.djbtest'.
The error occurred in D:\www\cfmx\scratch\bwconvertdata\test.cfm: line 30
28 :
29 : <cfquery name="InitVals" datasource="aaa_bwdatadump">
30 : INSERT INTO #getuser.owner#.djbtest ('id')
31 : VALUES ('sdfasdfafasdfasfd')
32 : </cfquery>
----------------------------------------------------------------------------
----
SQL INSERT INTO dbo.djbtest ('id') VALUES ('sdfasdfafasdfasfd')
DATASOURCE aaa_bwdatadump
VENDORERRORCODE 208
SQLSTATE 42S02
-------------------------------
If it makes any diff, it's on CFMX 7,0,2,137072 and MS-SQL2000 (8.00.2039
(SP4)), although I've got the same results on CF5 and MS-SQL SP3.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255181
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
