Jump to content
Sign in to follow this  
speedy6

SQL Problem

Recommended Posts

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)

Share this post


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

Share this post


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

Share this post


Link to post
Share on other sites
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 by speedy6

Share this post


Link to post
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
Sign in to follow this  

×