egghelp/eggheads community

mysqltcl | eggdrop 1.6.15 | mysql max 4.0.13 binary-install

2003-06-04T12:18:45-04:00

The flatlist option is very helpful, however, is mainly only there as a compatability feature.

The "foreach" command, allows you to pick more than a single item from a list in one go

Code:

set list {AAABACADBABBBCBDDADBDCDD}foreach {a b c d} $list {some code }

You should get an idea of what flat list is for now. You can cycle through rows very qucily, with access to values instantly.

Statistics: Posted by ppslim — Wed Jun 04, 2003 12:18 pm

mysqltcl | eggdrop 1.6.15 | mysql max 4.0.13 binary-install

2003-06-04T08:02:11-04:00

nevermind last post - i found that it just "pasted" a row into an index in the cute little list...

Statistics: Posted by gk^ — Wed Jun 04, 2003 8:02 am

mysqltcl | eggdrop 1.6.15 | mysql max 4.0.13 binary-install

2003-06-04T07:46:06-04:00

ok, well now I made it with -flatlist (witch is really useless when you think about for a secound).

Code:

   set mysql_handle [mysqlconnect -h localhost -user eggdrop -password xxxxxxx -db eggdrop]   set mysql_res [mysqlsel $mysql_handle "SELECT * FROM test" -list]   putlog "00: [lindex $mysql_res 0]"

but I cant figure out how to use

[lindex [mysqlsel ...] 0] is the first selected row, ...
and another lindex to select the correct column

I guess that its just to try but it would save me lots of time if you could give me and example..

Yours truly

gk^

Statistics: Posted by gk^ — Wed Jun 04, 2003 7:46 am

mysqltcl | eggdrop 1.6.15 | mysql max 4.0.13 binary-install

2003-06-04T07:31:15-04:00

yeah, using mysqlsel?
[lindex [mysqlsel ...] 0] is the first selected row, ...
and another lindex to select the correct column

Statistics: Posted by mortician — Wed Jun 04, 2003 7:31 am

mysqltcl | eggdrop 1.6.15 | mysql max 4.0.13 binary-install

2003-06-04T06:47:42-04:00

yes well, that isnt really a problem. Maybe I where unclear about my problem - I can putout like "{1 " or "1" but nothing more - should I use things such as lindex? Checking how to use them right now so that I can try..

Statistics: Posted by gk^ — Wed Jun 04, 2003 6:47 am

mysqltcl | eggdrop 1.6.15 | mysql max 4.0.13 binary-install

2003-06-04T06:13:16-04:00

There several ways to do this.

Reading tcl-commands.doc will be your best source for this.

Read up on putdcc, putlog

Statistics: Posted by ppslim — Wed Jun 04, 2003 6:13 am

mysqltcl | eggdrop 1.6.15 | mysql max 4.0.13 binary-install

2003-06-04T05:08:47-04:00

I have some trouble using mysqltcl.

I've read the doc (witch isnt that much of a help ) lots of times - but I cant figure out how to print the right data.

I use a select * from table, but how in the world should I put it out on ie. the partyline?

Yours truly

gk^

Statistics: Posted by gk^ — Wed Jun 04, 2003 5:08 am