Webmaster Forum / ColdFusion / Advanced Techniques / March 2007

Heres my complete code what im trying to achieve. In IE i get a http 500
internal error and in firefox i get a blank page. im strating to think it
may be a database permission problem although i have made sure my user has
full permissions on the order_history table.

any ideas whta im doing wrong?

<cfquery name="delete" datasource="#client.dsn#"
username="#client.username#" passWord="#client.password#">
delete from order_history
</cfquery>

<cfhttp timeout="900" method="get" textqualifier=" " firstrowasheaders="no"
columns="OrderNo,Line,seq,AccountNo,Shipment,Invoice,PurchaseOrder,Completed,OrderDate,ShipmentDate,Backorder,Product,QtyOrdered,QtyShipped,QtyInvoiced,Price,Carrier,Connote,Delivery1,Delivery2,Delivery3,Delivery4,Delivery5,Delivery6,Delivery7,expected"
delimiter="|" name="test" url="http://xxxxxxxx.com/prms/ordhist1.txt">
</cfhttp>

<cfloop query="test">

<cfquery name="insert" datasource="#client.dsn#"
username="#client.username#" passWord="#client.password#">
INSERT INTO order_history
(OrderNo, Line, seq, AccountNo, Shipment, Invoice, PurchaseOrder, Completed,
OrderDate, ShipmentDate, Backorder, Product, QtyOrdered, QtyShipped,
QtyInvoiced, Price, Carrier, Connote, Delivery1, Delivery2, Delivery3,
Delivery4, Delivery5, Delivery6, Delivery7, expected)
VALUES (
<cfqueryparam value='#test.OrderNo#' cfsqltype="cf_sql_integer">,
<cfqueryparam value='#test.Line#' cfsqltype="cf_sql_integer">,
<cfqueryparam value='#test.seq#' cfsqltype="cf_sql_integer">,
<cfqueryparam value='#test.AccountNo#' cfsqltype="cf_sql_integer">,
<cfqueryparam value='#test.shipment#' cfsqltype="cf_sql_integer">,
<cfqueryparam value='#test.invoice#' cfsqltype="cf_sql_integer">,
<cfqueryparam value='#test.purchaseorder#' cfsqltype="cf_sql_varchar"
maxlength="20">,
<cfqueryparam value='#test.completed#' cfsqltype="cf_sql_varchar"
maxlength="12">,
<cfqueryparam value='#test.orderdate#' cfsqltype="cf_sql_varchar"
maxlength="12">,
<cfqueryparam value='#test.shipmentdate#' cfsqltype="cf_sql_varchar"
maxlength="12">,
<cfqueryparam value='#test.backorder#' cfsqltype="cf_sql_varchar"
maxlength="10">,
<cfqueryparam value='#test.product#' cfsqltype="cf_sql_varchar"
maxlength="20">,
<cfqueryparam value='#test.qtyordered#' cfsqltype="cf_sql_integer">,
<cfqueryparam value='#test.qtyshipped#' cfsqltype="cf_sql_integer">,
<cfqueryparam value='#test.qtyinvoiced#' cfsqltype="cf_sql_integer">,
<cfqueryparam value='#test.price#' cfsqltype="cf_sql_varchar"
maxlength="15">,
<cfqueryparam value='#test.carrier#' cfsqltype="cf_sql_varchar"
maxlength="20">,
<cfqueryparam value='#test.connote#' cfsqltype="cf_sql_varchar"
maxlength="20">,
<cfqueryparam value='#test.delivery1#' cfsqltype="cf_sql_varchar"
maxlength="150">,
<cfqueryparam value='#test.delivery2#' cfsqltype="cf_sql_varchar"
maxlength="100">,
<cfqueryparam value='#test.delivery3#' cfsqltype="cf_sql_varchar"
maxlength="100">,
<cfqueryparam value='#test.delivery4#' cfsqltype="cf_sql_varchar"
maxlength="100">,
<cfqueryparam value='#test.delivery5#' cfsqltype="cf_sql_varchar"
maxlength="100">,
<cfqueryparam value='#test.delivery6#' cfsqltype="cf_sql_varchar"
maxlength="100">,
<cfqueryparam value='#test.delivery7#' cfsqltype="cf_sql_varchar"
maxlength="100">,
<cfqueryparam value='#test.expected#' cfsqltype="cf_sql_varchar"
maxlength="12">)

</cfquery>

</cfloop>

FINISHED!!

i'll check it out using MX7 on a II's server

Thanks for help guys it seems to be a file size problem.

the text file I was reading was 25mb and cfhttp seems to die, as it loads it
into a query set.

Under 20mb and my code seems to work ok.