I'm working on speeding up an EDI file import. The existing code does an insert via CFQUERY for every po header & line item imported.I'm trying to contrive a way to gather all the pos & line items beforehand so I can do just two inserts, one for po headers and one for line items. The approach I'm trying involves programmatically generating a CFGRID by looping through an array of structs & creating a CFGRIDROW for each record. (There are two grids, one for po headers, and one for line items.) I have a couple of questions about this, though. First of all, how does the grid flag a record for insertion? Is there a programmatic technique to flag my CFGRIDROWs as new records so the CFGRIDUPDATE command inserts the records? Or are all CFGRIDROWs automatically considered new records, and thus inserted? Second, I plan on running this as a scheduled process. Will a scheduled process execute javascript (to automatically submit the form)? If not, how do I get the form to submit? Third, does anyone have any bright ideas about alternative approaches? My goal, remember, is to reduce the number of CFQUERY objects to the bare minimum. I'm running CF4 & SQL Server 7. Could I skin this cat with a stored procedure? If so, how would I pass the po's (or line items) to the stored proc? Some of these files contain thousands of records, which exceeds both the max number of params to a stored proc and the max string size for varchar. BULK INSERT doesn't seem to be an option, either, since the SQL Server box is on the wrong side of the DMZ to see files on the web server. Any bright ideas? Thanks! ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
