[MySQL] Not doing anything with mysqltcl

T-Xorcist · Post by **T-Xorcist** » Tue May 09, 2006 7:21 pm

Hi all!

I just started to work with mysqltcl, but I can't find the error. I have the following code:

proc test {nick host hand chan arg} {
  package require mysqltcl
  set mysql(conn) [mysqlconnect -host localhost -user tbot -db tbot -password xxxxxxx]

  [b][u]set query "SELECT id FROM channels WHERE name = 'T-Xorcist'"
  set chanid [mysqlsel $mysql(conn) $query -list][/u][/b]

  mysqlclose $mysql(conn)
}

The wanabee bold/underlined lines are the problem! If I remove that line, it works.

What is wrong with this script? I am looking for 3 hours now

Thanks in advance!

demond · Post by **demond** » Wed May 10, 2006 1:11 am

T-Xorcist wrote: What is wrong with this script? I am looking for 3 hours now

the 'wanabee bold/underlined lines'?

T-Xorcist · Post by **T-Xorcist** » Wed May 10, 2006 9:23 am

Hm, my MySQL user / password wasn't correct :S

Which is very strange, because it is there. Oh wel, sorry for bothering you guys

1 more question: how can I remove all the channels at ones? like:
channel remove * ? Is that possible?

De Kus · Post by **De Kus** » Wed May 10, 2006 8:05 pm

T-Xorcist wrote:1 more question: how can I remove all the channels at ones? like:
channel remove * ? Is that possible?

Try it. I am for sure NOT going to try it on my bot

.

T-Xorcist · Post by **T-Xorcist** » Thu May 11, 2006 2:36 am

But what is it?

Any ideas?

egghelp/eggheads community

[MySQL] Not doing anything with mysqltcl

[MySQL] Not doing anything with mysqltcl

Re: [MySQL] Not doing anything with mysqltcl