egghelp/eggheads community Discussion of eggdrop bots, shell accounts and tcl scripts. 2006-01-19T01:25:49-04:00 https://forum.eggheads.org/app.php/feed/topic/11204 2006-01-19T01:25:49-04:00 2006-01-19T01:25:49-04:00 https://forum.eggheads.org/viewtopic.php?p=59530#p59530 <![CDATA[How to search a list of results from an sql query?]]>

Code: 

...mysqlmap $db {id name score kills} {...lappend ::result [list $id $name $score $kills]...}
then you'll be able to sort by index in sublist:

Code: 

proc foo {...} {...# sort by nameset ::result [lsort -index 1 $::result]...}
refer to lsort manpage for more info and examples

Statistics: Posted by demond — Thu Jan 19, 2006 1:25 am

]]> 2006-01-18T05:15:14-04:00 2006-01-18T05:15:14-04:00 https://forum.eggheads.org/viewtopic.php?p=59513#p59513 <![CDATA[How to search a list of results from an sql query?]]>
The select query will be something like

Code: 

 mysqlsel $mysql "SELECT * FROM sql_table where last_event < $time" set mycount [mysqlresult $mysql rows?]  mysqlmap $mysql {id name score kills} { }

I have googled and searched the forum and found a few matches but I can’t get what I'm trying to do to work and don’t seem to be getting any error messages to help work out why it’s not working.

Once I have the results from the query I need to build a list of id, name, score and kills and sort first on score (DESC) and then on kills (DESC). That bit of the problem I can do with the actual select statement. The bit I'm having problems with is I need to somehow generate an index number for each result starting from 1 and ending with the last result to the query as follows

Code: 

  Index    name     score   kills  1        name1    100     20  2        name4    95      15  3        name2    82      10  4        name5    82      8  5        name3    60      5
From this list I then need to do a search for a particular name and select that whole row but the important part of the row will be the index number for that row. I’ve seen references to lsearch and think this may be the way to do it but in not sure how to actually implement it.

Can anyone offer me any help or guidance with this script?

TIA

Regards

Reserve

Statistics: Posted by Reserve — Wed Jan 18, 2006 5:15 am

]]>