[RESOLVED] Database INT values

Hello,

I 'm not sure if this is the right place to post about this, but I do like to learn from here and there, so here is my question:

I'm building my site with a server offering many capabilities among which the connection to mysql databases through its extensions which I only know how to code a little with AS 2.

I want to build a form or gueestbook that connects to one, but I can't make it insert data into it unless the INT value in the database is BIGINT if I want to have it autoincrement itself chronologically. My doubt is whether that is due to my client side in AS 2 or how I prepare the database.

In the client side, Flash I have this code to insert the values into the database:

Code:

---

function addRecord()
{
        var req:Object = {}
       
        if (add_name_txt.text != "")
        {
                req.name                = add_name_txt.text
                req.location        = add_location_txt.text
                req.email                = add_email_txt.text
               
                // Clear textfields
                add_name_txt.text = add_location_txt.text = add_email_txt.text = ""
               
                smartfox.sendXtMessage(extensionName, "addData", req, "xml")
        }
}

---

In the extension :

Code:

---

else if (cmd == "addData")
        {
                var id = getTimer()

                var sql = "INSERT INTO contacts (id, name, location, email) VALUES ("
                sql += "'" + id + "', "
                sql += "'" + _server.escapeQuotes(params.name) + "', "
                sql += "'" + _server.escapeQuotes(params.location) + "', "
                sql += "'" + _server.escapeQuotes(params.email) + "')"
               
                var success = dbase.executeCommand(sql)
                {
                        var response                = {}
                        response._cmd                = "addData"
                        response.id                = id
                        response.name                = params.name
                        response.location        = params.location
                        response.email                = params.email
                       
                        _server.sendResponse(response, -1, null, [user])
                }
        }

---

In the database the Id row is BIGINT (20) and the rest of the fiels are varchar 255. If I try to make it INT(11) and autoincrement on, nothing is added to the database.

I still haven't tried getting rid off the getTimer variable and changing the database again, could that be it? Whenever I look into the id values are very large, like this one: 1382786279642