Jump to content

Recommended Posts

Posted

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 

#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 

 

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...