<?xml version="1.0" encoding="UTF-8"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en-gb">
	<link rel="self" type="application/atom+xml" href="https://forum.eggheads.org/app.php/feed/topic/6553" />

	<title>egghelp/eggheads community</title>
	<subtitle>Discussion of eggdrop bots, shell accounts and tcl scripts.</subtitle>
	<link href="https://forum.eggheads.org/index.php" />
	<updated>2004-01-05T11:05:55-04:00</updated>

	<author><name><![CDATA[egghelp/eggheads community]]></name></author>
	<id>https://forum.eggheads.org/app.php/feed/topic/6553</id>

		<entry>
		<author><name><![CDATA[nso]]></name></author>
		<updated>2004-01-05T11:05:55-04:00</updated>

		<published>2004-01-05T11:05:55-04:00</published>
		<id>https://forum.eggheads.org/viewtopic.php?p=32231#p32231</id>
		<link href="https://forum.eggheads.org/viewtopic.php?p=32231#p32231"/>
		<title type="html"><![CDATA[ot: arrayproblem?]]></title>

		
		<content type="html" xml:base="https://forum.eggheads.org/viewtopic.php?p=32231#p32231"><![CDATA[
oh the wonderfull magic that 'join' can perform.<br>thanks to a kind soul on irc for this little tidbit of information<p>Statistics: Posted by <a href="https://forum.eggheads.org/memberlist.php?mode=viewprofile&amp;u=3074">nso</a> — Mon Jan 05, 2004 11:05 am</p><hr />
]]></content>
	</entry>
		<entry>
		<author><name><![CDATA[nso]]></name></author>
		<updated>2004-01-05T10:00:18-04:00</updated>

		<published>2004-01-05T10:00:18-04:00</published>
		<id>https://forum.eggheads.org/viewtopic.php?p=32229#p32229</id>
		<link href="https://forum.eggheads.org/viewtopic.php?p=32229#p32229"/>
		<title type="html"><![CDATA[ot: arrayproblem?]]></title>

		
		<content type="html" xml:base="https://forum.eggheads.org/viewtopic.php?p=32229#p32229"><![CDATA[
i know this is an 3rd-party program, and thus not exactly ontopic for egghelp. But since there may be some people here whom have experienced the same I thought I'd have a go at it.<br><br><br>I get a problem when I am collection more then one column from a row in my mysql-db using <strong class="text-strong">fbsql</strong><br><br>When I am fetching a single column it is similar to this:<div class="codebox"><p>Code: </p><pre><code>        set row [sql "SELECT id FROM list_setitem WHERE id='$text'"]        if { $row == ""} {                putdcc $brukerid "No matches to your query - $text -. Please redefine your searchstring."                sql disconnect                return 0        } else {                putdcc $brukerid "\002You are now offering $row\002\nRemember to update your webpage! (.update)"                sql disconnect                return 0        }</code></pre></div>the output is<div class="codebox"><p>Code: </p><pre><code>&lt;nso&gt; .+offer 41&lt;d2&gt; You are now offering 41&lt;d2&gt; Remember to update your webpage! (.update)</code></pre></div><br>this is all fine and dandy.<br>but if I want to select more columns, this is the result:<br>(selecting 'id,name' in the sql instead of just 'id')<br><div class="codebox"><p>Code: </p><pre><code>&lt;nso&gt; .+offer 123&lt;d2&gt; You are now offering {123 {Trang-Oul's Guise}}&lt;d2&gt; Remember to update your webpage! (.update)</code></pre></div><br>So basicly there is generated unwanted {} around the individual columns.<br>When utilizing the full script I'm off course going to use lindex to split the variable up, but that is made very difficult by these {}.<br>I could off course use regsub, but that is a dirty solution, and I would really like to have a better way of doing it.<br><br>Any feedback would be appreciated.<br><br><br>Cheers, nso<br><br><br><br>edit: just realized that I had pasted the wrong bit of code. sorry. corrected now<p>Statistics: Posted by <a href="https://forum.eggheads.org/memberlist.php?mode=viewprofile&amp;u=3074">nso</a> — Mon Jan 05, 2004 10:00 am</p><hr />
]]></content>
	</entry>
	</feed>
