This is the new home of the egghelp.org community forum.
All data has been migrated (including user logins/passwords) to a new phpBB version.


For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.

Search found 8 matches

by prozzerg
Sat Jan 01, 2005 3:34 pm
Forum: Archive
Topic: problem with mysql select
Replies: 14
Views: 6086

so, now everything works, i found the problem. thanks for the help and sorry for my stupidness ;)
by prozzerg
Sat Jan 01, 2005 2:39 pm
Forum: Archive
Topic: problem with mysql select
Replies: 14
Views: 6086

i dont know whats wrong, but .set errorInfo does NOT work, no matter what i do. this is what i get when i log in, it says that im the owner and so on. 19:28 <bot> Connected to bot, running eggdrop v1.6.15 19:28 <bot> ____ __ 19:28 <bot> / __/___ _ ___ _ ___/ /____ ___ ___ 19:28 <bot> / _/ / _ `// _ ...
by prozzerg
Sat Jan 01, 2005 2:05 pm
Forum: Archive
Topic: problem with mysql select
Replies: 14
Views: 6086

well, the unbinds where already taken away, so thats not the problem, i did a .help set, this is the output 19:01 <Prozzerg> .help set [19:01] #Prozzerg# help set ### set <variable> [value] Changes the values of config-file settings of the bot, or, if used without a value parameter, shows the curren...
by prozzerg
Sat Jan 01, 2005 1:33 pm
Forum: Archive
Topic: problem with mysql select
Replies: 14
Views: 6086

on !search Paul Van Duk

Code: Select all

[18:32] Tcl error [pub:search]: expected integer but got "-Van"
.set errorInfo
What?  You need '.help'
by prozzerg
Sat Jan 01, 2005 9:49 am
Forum: Archive
Topic: problem with mysql select
Replies: 14
Views: 6086

Theres the code. and the error message is always with the second word, like this:
[03:54] Tcl error [pub:search]: expected integer but got "-secondword"

If i search only on one word everything works as it should.
by prozzerg
Sat Jan 01, 2005 9:43 am
Forum: Archive
Topic: problem with mysql select
Replies: 14
Views: 6086

set mysql(host) "localhost" set mysql(port) "3306" set mysql(user) "user" set mysql(pass) "pass" set mysql(data) "infodb" load /usr/lib/mysqltcl-2.50/libmysqltcl2.50.so set mysql(conn) [mysqlconnect -host $mysql(host) -port $mysql(port) -user $mysql(...
by prozzerg
Fri Dec 31, 2004 11:26 pm
Forum: Archive
Topic: problem with mysql select
Replies: 14
Views: 6086

i use this one: "SELECT * FROM `info` where `text` = '$string'" (full command is: mysqlsel $mysql(conn) "SELECT * FROM `info` where `text` = '$string'" -list ) i set string to "hello this is a test" i get this output: [03:54] Tcl error [pub:search]: expected integer but...
by prozzerg
Fri Dec 31, 2004 11:09 pm
Forum: Archive
Topic: problem with mysql select
Replies: 14
Views: 6086

problem with mysql select

I have a problem with this select row when $string includes spaces, does someone know if there is possible to have spaces in this way? foreach query [mysqlsel $mysql(conn) "SELECT * FROM `info` where `text` = '$string'" -list] if i have it this way it works, but then the question is wrong:...