Webboard: Displaying site tag in search result?

Author: Michael Graziano
Email: mgrazianoinvision.net
Message:
Replying to my own bad SQL, aside from the syntax error in
what I originally posted this seems to work pretty well from
the SQL interpreter, but there's a problem when I call it
from the template:


<!UDMENV NAME="ENV"
CONTENT="Default">
<!SQLQuery NAME="Env" CONTENT="SELECT
tag FROM server WHERE server.rec_id = (SELECT server_id FROM
url WHERE url='$URL')"
RESULT="SQLRes">

<!IFGT NAME=SQLRes.num_rows"
CONTENT="0">
<!SQLFetch NAME="SQLRes"
RESULT="SQLRow">
$(SQLRow.0)<br>
<!ELSE>
NO RESULT FOR TAG!
<!ENDIF>

always tells me there was no result for tag (SQLRes.num_rows
always 0).  I've tried $URL, $(URL) and URL for the URL
Value, Do I need to do magic with that $URL to get the
variable's value into the SELECT?

I was also unable to find reference to this in the
msearch-test in my distribution (3.2.35) or the latest
3.2.37 - If this is just in the CVS release I'm not opposed
to checking that out (although I'd like it better if I
don't have to blow away my database to do the upgrade...)

Thanks (again)



Reply: <http://www.mnogosearch.org/board/message.php?id=17601&g
t;


------------------------------------------------------------
---------
To unsubscribe, e-mail: general-unsubscribemnogosearch.org
For additional commands, e-mail: general-helpmnogosearch.org