faustf Posted August 7, 2018 Posted August 7, 2018 hi guys i have a @mLipok UDF for work with mysql but my ssript return my this error Test 1 [ 5 / 0 ] and dont insert nothing inside of db this is my code expandcollapse popup#cs ---------------------------------------------------------------------------- AutoIt Version: 3.3.14.2 Author: faustf Script Function: Template AutoIt script. #ce ---------------------------------------------------------------------------- ; Script Start - Add your code below here #include <Array.au3> #include "include\ADO.au3" ; include function for adodb #include "include\DBnoGUI.au3" ; include function di aggancio del db + futuribile new Usql language ;_ConnectDB_gest() _main() Func _main() Local $aLArticoli = FileReadToArray(@ScriptDir & "\WEB-SITE\Runner\ftp\articoli.txt") ; articoli If @error Then MsgBox($MB_SYSTEMMODAL, "", "There was an error reading the file. @error: " & @error) ; An error occurred reading the current script file. Else For $i = 1 To UBound($aLArticoli) - 1 Local $aLAtomArticle = StringSplit($aLArticoli[$i], "|") ;_ArrayDisplay($aLAtomArticle) Local $sLSyntax = "INSERT INTO ge_runner_listino (codice,codice_Produtt,codice_EAN,DescProd,Produttore,Famiglia,DescCatMerc,Dispo,PrezzoNoSconto,PrezzoSiSconto,Grossista)" & _ " VALUES ('" & $aLAtomArticle[1] & "','" & $aLAtomArticle[2] & "','" & $aLAtomArticle[3] & "','" & $aLAtomArticle[4] & "','" & $aLAtomArticle[5] & "','" & $aLAtomArticle[6] & "','" & _ $aLAtomArticle[8] & "','" & $aLAtomArticle[9] & "','','','Runner')" Local $sLQueryResult = _Mysql_Query($sLSyntax) If @error Then SetError(@error, @extended, $ADO_RET_FAILURE) EndIf Next EndIf EndFunc ;==>_main anyone can help me ?? thankz
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now