script wont apply changes

[goldenix]

This is where I got the script _sql.au3 can also be gotten from there.

http://www.autoitscript.com/forum/index.ph...=51952&st=0

This code there is really super, just 1 question, Why my database is not being updated if I run this?

My table looks like this:

column1     column2
    101         127.0.0.1
    101         127.0.0.1

#include <_sql.au3>

$con = _SQLStartup()
_SQLConnect(-1,"localhost","test_db","sa","123456")

$data = _SQLExecute(-1,"UPDATE Table1 SET column2 = '128.0.0.1' WHERE column1 = '101';")

_SQLClose()

EDIT: I figured it out...totally from the blue tho... looks like the sign & was missing see below

$data = _SQLExecute(-1,"UPDATE Table1 SET column2 = '" & $PublicIP & "' WHERE column1 = '101';")

to be more spesific:

$data = _SQLExecute(-1,"UPDATE Person SET FirstName = 'Nina' "   &   "  WHERE LastName = 'Rasmussen'";)

Edited December 10, 2007 by goldenix

[weaponx]

If this is the exact code you used your SQL syntax is wrong.

$data = _SQLExecute(-1,"UPDATE Table1 SET column2 = '128.0.0.1' WHERE column2 = '101';")

should be

$data = _SQLExecute(-1,"UPDATE Table1 SET column2 = '128.0.0.1' WHERE column1 = '101';")