MySQL Update script

[cvanmeer]

I've got the following script. The idea is to put this on the end of a proc and so, count the number of times, the script has been used.

Table layout: id, commando, aantal (where aantal is the field which I want to update)

Table has 1 (test) row: id=1, commando=!test, aantal=0

Code: Select all

proc user {nick host hand chan text} {
 package require sql

 set conn [sql connect $host $user $pwd]
 set res [catch {sql selectdb $conn $db} msg]

 set output [sql query $conn "SELECT MAX(aantal) FROM nROServ WHERE commando LIKE '!test'"]
 set row [sql fetchrow $conn $output]
 set aantal $row
 putlog "$aantal"
 incr $aantal
 set omhoog [sql exec $conn "UPDATE nROServ SET aantal = '$aantal' WHERE commando LIKE '!test'"]

 sql disconnect $conn
}

But when I run the script, I get the following error:
Tcl error [user]: can't read "0": no such variable

The error might be the incr $aantal but I don't know for sure.

Could someone advice me what to do?

thx

Chrizz

[GodOfSuicide]

change incr $aantal to incr aantal

[cvanmeer]

thx!!
what a simple typo can do

[CrazyCat]

it's more than a typo, it's an important prefix

[Axl]

u have

Code: Select all

package require sql 

I need to write a tcl script that uses mysql too and Im guessing this is the first place to start.. where can I get this package to install on my server?

Cheers

[Neomaster]

u have

Code: Select all

package require sql 

I need to write a tcl script that uses mysql too and Im guessing this is the first place to start.. where can I get this package to install on my server?

Cheers

Yeah... where could we get it??

I have Msql , MySql , Tcl8.4 , MysqlTcl , but still missing that "sql" package...

package require sql