I am trying to submit the following through a cfm page <cfquery name="up" datasource="#dbname#"> BULK INSERT stgContacts FROM 'C:\CFusionMX\wwwroot\ileaflet\clients\1 \contacts.txt' WITH (FIELDTERMINATOR = '|') </cfquery>
however it will not work. From Query Analyzer logged on wiht teh same user as the the user running the page I can run the command no problem but from the CFM page it is a no go. Yes the user has BULK INSERT privs ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2791 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
