SQL Problem

[speedy6]

With this code, i always get the error:

$oconnextionobj.execute($query)^EEROR

Error: The requested action with thos object had failed.

#include "SQL.au3"

dim $cvalues[2]
$cvalues[0] = "TEST"
$cvalues[1] = "";make sure u have one extra blank element
        
            
$sql = _MySQLConnect("vidam2","*****","vidam2","mysql02.combell.com")
_AddRecord($sql, 'tblusers', 'pcnaam', $cvalues) 

_MySQLEnd($sql)

[Zedna]

without "SQL.au3" sources and used queries we can't help you.

[speedy6]

without "SQL.au3" sources and used queries we can't help you.

how do you mean, the sql.au3 is the same file I've found on tthis forum. but here it is...(attachment)

[Zedna]

Do error checking, something like this:

#include "SQL.au3"

dim $cvalues[2]
$cvalues[0] = "TEST"
$cvalues[1] = "";make sure u have one extra blank element
        
            
$sql = _MySQLConnect("vidam2","*****","vidam2","mysql02.combell.com")
If @error Then
  MsgBox(0,'Error','Error in connection attempt!')
  Exit
EndIf

_AddRecord($sql, 'tblusers', 'pcnaam', $cvalues) 
_MySQLEnd($sql)

[speedy6]

I keep getting the same error...

**EDIT***

solved, he has problems with arrays, but if you use just a string, , the problem is solved.!

Edited June 7, 2007 by speedy6