Jump to content
Sign in to follow this  
Cyrille

Mysql.au3 error with include

Recommended Posts

Cyrille

Hello !

First, I am french that's why i haven't a good english and i don't understand all that you say ^^

I have a problem with the include : mysql.au3 : http://www.autoitscript.com/forum/index.ph...mp;hl=mysql.au3

I can use it in my script without error. But when it executes these lines :

$sql = _MySQLConnect("math", "password", "math", $serveur); connexion à la base de donnée
    Dim $values[6]
    $values[0] = ""
    $values[1] = $identifiant
    $values[2] = GUICtrlRead($message)
    $values[3] = @MDAY & "/"& @MON &"/"&@YEAR
    $values[4] = @HOUR&"h"&@MIN&"min"&@SEC
    $values[5] = ""
    Dim $rows[6]
    $rows[0] = "id"
    $rows[1] = "iduser"
    $rows[2] = "contenu"
    $rows[3] = "date"
    $rows[4] = "heure"
    $rows[5] = ""
    _AddRecord($sql, 'discution', $rows, $values)
    _MySQLEnd($sql)

I have this error :

D:\AutoIt\Mysql\mysql.au3 (131) : ==> The requested action with this object has failed.:

$oconnectionobj.execute ($query)

$oconnectionobj.execute ($query)^ ERROR

I have try whit this code :

$sql = _MySQLConnect("math", "cpassword", "math", $serveur); connexion à la base de donnée
    Dim $values[6]
    $values[0] = ""
    $values[1] = $identifiant
    $values[2] = GUICtrlRead($message)
    $values[3] = @MDAY & "/"& @MON &"/"&@YEAR
    $values[4] = @HOUR&"h"&@MIN&"min"&@SEC
    $values[5] = ""
    Dim $rows[6]
    $rows[0] = "id"
    $rows[1] = "iduser"
    $rows[2] = "contenu"
    $rows[3] = "date"
    $rows[4] = "heure"
    $rows[5] = ""
    _Query($sql,"INSERT INTO discution (id, iduser, contenu, date, heure) VALUES ('','cyrille','blablabla','21/05/1990','21h05min30')");    
the content of the rows is only for testing
    _MySQLEnd($sql)

And i have the same error...

I don't understand... Can you help me please ?

Share this post


Link to post
Share on other sites
Cyrille

I have found me error...

My table had not the same colum as my script :

table : "userid"

script : "iduser"

;):(:):mellow: and more...

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  

×