Jump to content

SQL Problem


Recommended Posts

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

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)
Link to comment
Share on other sites

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
 Share

  • Recently Browsing   0 members

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