I guess you need to use Plain SQL without aliases like the following:
INSERT INTO MacAddresses (MacAddress, Port)
SELECT MacAddress, Port
FROM DeviceStaging
WHERE MacAddress NOT IN (SELECT MacAddress FROM MacAddresses)
Greetings / Grüsse
Gert Franz
Customer Care
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch
Join our Mailing List / Treten Sie unserer Mailingliste bei:
deutsch: http://de.groups.yahoo.com/group/railo/
english: http://groups.yahoo.com/group/railo_talk/
Robert Rawlins - Think Blue schrieb:
> 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
>>
>>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276047
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
