Sign in to follow this  
Followers 0
Meszaros Csaba

MySQL error in MySQL.au3 l

1 post in this topic

#1 ·  Posted (edited)

Hi,

I've created a database in MyQL called 'plebania' with a table 'szemelyek'. It has 3 columns: keresztnev, szuletes and lakcim. I'm testing a frontend written in AutoIt:

#include <MySQL.au3>

$knev=InputBox("Keresztnev","Irj")

$dtum=InputBox("Datum","YYYY -MM-DD ")

$cim=InputBox("Cim","Irj")

dim $values[4]

$values[0] = Chr(34)&$knev&Chr(34)

$values[1] = Chr(34)&$dtum&Chr(34)

$values[2] = Chr(34)&$cim&Chr(34)

$values[3] = ""

$sql = _MySQLConnect("root","csaba","plebania","localhost")

_AddRecord($sql, 'szemelyek', $values, $values)

_MySQLEnd($sql)

Something must be wrong, cos I'm getting error message:

Line 132 (File "Program Files\AutoIt\Include\MySQL.au3"):

$oconnectionobj.execute(@query)

$oconnectionobj.execute(@query)^Error!

Error: The requested action with this object has failed

What's wrong ?

Edited by Meszaros Csaba

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  
Followers 0