Following on from my query this morning about the stored proc, I've started
dabbling with the query in CF to start with, just as it feels more familiar.
I'm struggling to get the following piece of code working though:
<cfquery name="qCommitLogs" datasource="MyDSN">
BULK INSERT DeviceStaging
FROM 'D:\test.txt'
WITH (FIELDTERMINATOR = ',')
</cfquery>
<p>Done</p>
This just returns a blank page, no error messages and nothing gets inserted
into the database table. Both the TXT file and DeviceStaging are 4 columns
and the datatypes appear to match.
00:00:00:00:00,1,2007-01-01 12:00:00,1
00:00:00:00:00,1,2007-01-01 12:00:00,1
00:00:00:00:00,1,2007-01-01 12:00:00,1
00:00:00:00:00,1,2007-01-01 12:00:00,1
00:00:00:00:00,1,2007-01-01 12:00:00,1
Columns are:
MacAddress Varchar(50)
Port TinyInt
DateTime DateTime
Class TinyInt
Any ideas on where to started with this?
Thanks,
Rob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276010
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
