funktioniert so nicht!
$s_Row_txt = StringTrimRight($s_Row_txt, 1)
string = BU_NR,ERF_DAT,SB_MA,AG_NR,KU_NR,MAILADRESSE,TYP
$s_Row_txt --> gibt mir nur den letzten eintrag aus dem string, also den wert, der bei TYP steht
[autoit]
For $x = 2 to $aRecords[0]
;Msgbox(0,'Record:', $aRecords[$x])
$s_Row_txt_t1 = StringSplit($aRecords[$x], ";")
$s_Row_txt=''
For $i = 1 To $s_Row_txt_t1[0]
$s_Row_txt_t1[$i] = _MySQL_Real_Escape_String($MysqlConn, $s_Row_txt_t1[$i])
$s_Row_txt = "'" & $s_Row_txt_t1[$i] & "' ,"
Next
$s_Row_txt = StringTrimRight($s_Row_txt, 1)
Local $sQuery = "INSERT INTO otmailid (BU_NR,ERF_DAT,SB_MA,AG_NR,KU_NR,MAILADRESSE,TYP) VALUES (" & $s_Row_txt & ")" & _
" ON DUPLICATE KEY UPDATE `ERF_DAT` = (" & "'" & $s_Row_txt_t1[2] & "'" & ") ," & _
"`SB_MA` = (" & "'" & $s_Row_txt_t1[3] & "'" & ")," & _
"`AG_NR` = (" & "'" & $s_Row_txt_t1[4] & "'" & ")," & _
"`KU_NR` = (" & "'" & $s_Row_txt_t1[5] & "'" & ")," & _
"`MAILADRESSE` = (" & "'" & $s_Row_txt_t1[6] & "'" & ")," & _
"`TYP` = (" & "'" & $s_Row_txt_t1[7] & "'" & ")"
;MsgBox(0,"",$sQuery)
_MySQL_Real_Query($MysqlConn, $sQuery)
[/autoit][autoit][/autoit][autoit]Next
[/autoit]gruß gmmg