Thanks AJ, That's all sorted now. :-D
Next part of my query is now causing problems (again with no CF error, Doh!)
I'm trying to move all mac address's that don't currently exists in the
MacAddress table from the DeviceStaging table.
INSERT INTO MacAddresses (MacAddress, Port)
SELECT DeviceStaging.MacAddress, DeviceStaging.Port
FROM DeviceStaging
WHERE DeviceStaging.MacAddress NOT IN (SELECT MacAddress
FROM MacAddress)
Any ideas why this won't run? When placing it through query analyzer it
tells me:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'DeviceStaging'.
But I defiantly have a table called DeviceStaging as that's where the import
happens.
Thanks,
Rob
-----Original Message-----
From: AJ Mercer [mailto:[EMAIL PROTECTED]
Sent: 23 April 2007 15:17
To: CF-Talk
Subject: Re: Bulk Insert
did this come through before?
maybe a permissions thing
=>http://msdn2.microsoft.com/en-us/library/ms188365.aspx
Requires INSERT and ADMINISTER BULK OPERATIONS permissions
Wrap a cftry around the cfquery and dump cfcatch
On 4/23/07, Robert Rawlins - Think Blue
<[EMAIL PROTECTED]>
wrote:
>
> Thanks for the suggestions guys,
>
> I just changed the user to sa in the admin panel for my data source and it
> worked right off, whch would suggest this IS a permissions issue with my
> DB
> user, any ideas what rights they need? They currently have datareader and
> datawriter access to the db but that's it.
>
> Thanks,
>
> Rob
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276045
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
