speedy6 Posted June 5, 2007 Share Posted June 5, 2007 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) Link to comment Share on other sites More sharing options...
Zedna Posted June 5, 2007 Share Posted June 5, 2007 without "SQL.au3" sources and used queries we can't help you. Resources UDF ResourcesEx UDF AutoIt Forum Search Link to comment Share on other sites More sharing options...
speedy6 Posted June 5, 2007 Author Share Posted June 5, 2007 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) Link to comment Share on other sites More sharing options...
Zedna Posted June 5, 2007 Share Posted June 5, 2007 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) Resources UDF ResourcesEx UDF AutoIt Forum Search Link to comment Share on other sites More sharing options...
speedy6 Posted June 7, 2007 Author Share Posted June 7, 2007 (edited) 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 Link to comment Share on other sites More sharing options...
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