I have a code which is suppose to update a single entry in the db.
The connection to the db is fine, it works and displays the correct data.
The sql query is fine as well, it does update the db if I use it in MS SQL Server.
Problem: the code does not update the db entry.
$mssql_server_name = "server_name";
$url = "http://url;
$userName = "user_name";
$password = "passwd";
$connString = "tsql -H $mssql_server_name -p 1234 -U $userName -P $pas
+sword -t '\<newrow\>' -o qh \<\< quit\n";
#Query to grab records created
$cmd = $connString."update [dbname].[record] set record = 7\nGO\nquit\
$cmd = $connString."select * from [dbname].[record]\nGO\nquit\n";
$result = `$cmd`;
print "RESULT $result\n";