Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <cffile action="read" file="#expandPath('/admin/_test/ofspazio.csv')#" variable="csvfile" />
- <cfloop index="index" list="#csvfile#" delimiters="#chr(10)##chr(13)#">
- <cfif listLen(index) GTE 7 AND isNumeric(listGetAt(index,6)) AND isNumeric(listGetAt(index,7))>
- <cfloop from="1" to="#listGetAt(index,7)#" step="1" index="i">
- <cfquery datasource="spazio_visione">
- INSERT INTO
- ordini_al_fornitore
- SET
- data_ordine = '2015-07-06',
- barcode = '#listGetAt(index,6)#',
- qta_ordinata = 1,
- fornitore = 'LUXOTTICA',
- ana_negozi = 2,
- ana_negozi_dest = 1,
- gg_attesa = 50,
- data_consegna = '2015-08-25',
- id_operatore = 120,
- note = '_automatico',
- data_aggiornamento = '2015-07-06 00:00:00',
- utente = 'lux.cristina',
- ana_tipo_ordine =2,
- priorita=2,
- qta_consegnata = 0,
- prezzo_ordine = 109.00,
- consegnato_tipo_documento = 'B'
- </cfquery>
- </cfloop>
- </cfif>
- </cfloop>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement