egghelp/eggheads community

MySQL Update script

2004-02-26T15:49:44-04:00

u have
Code:
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

Statistics: Posted by Neomaster — Thu Feb 26, 2004 3:49 pm

MySQL Update script

2004-01-15T15:34:30-04:00

u have

Code:

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

Statistics: Posted by Guest — Thu Jan 15, 2004 3:34 pm

MySQL Update script

2004-01-15T13:16:10-04:00

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

Statistics: Posted by CrazyCat — Thu Jan 15, 2004 1:16 pm

MySQL Update script

2004-01-15T09:47:12-04:00

thx!!
what a simple typo can do

Statistics: Posted by cvanmeer — Thu Jan 15, 2004 9:47 am

MySQL Update script

2004-01-15T08:16:03-04:00

change incr $aantal to incr aantal

Statistics: Posted by GodOfSuicide — Thu Jan 15, 2004 8:16 am

MySQL Update script

2004-01-15T03:53:44-04:00

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:

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

Statistics: Posted by cvanmeer — Thu Jan 15, 2004 3:53 am