Thunderstone Support Forums

Then you probably want to use Jason's idea:

<sql "select String from options where Name='SS_db' and Profile=$pr">
</sql>
<DB=$String>

Related thread http://thunderstone.master.com/texis/ma ... 4bbfc8ed10

Ok, I have run into a brick wall. Everything I have tried doesn't work, or returns a linear search error. When I use the built in search, it all works fine.

Can someone post how to modify the main search script so that the results are returned as XML?

Thanks,
Erick

Based on John's earlier suggestion you could add something like

<a name=atom PUBLIC>
<init>
<hits>
<sql row max=10 "select * from html where " $SSc_searchfields " likep $query">
<setupresult>
<hit>
<hitnum>$next</hitnum>
<title><fmt $qdispfmt $Title></title>
<url><fmt $qdispfmt $Url></url>
<hitabs><fmt $qdispfmt $dabstract></hitabs>
</hit>
</sql>
</hits>
</a>

Display more fields as needed.

Thanks Mark. Once I have that in, how do I call it from the URL (or do I need to modify something else)?

Thanks,
Erick

Similar to "search" except the part after search changes.
http://yourmachine/cgi-bin/texis/webina ... =yourquery

Bingo! Thanks much for your help!

Erick

This is working out well, but I am looking for a list of additional columns/fields I can select from (size, etc). Is there a list somewhere with the values I can use?

Thanks,
Erick

See http://www.thunderstone.com/site/webina ... s_and.html

Also look in the script for the create table statement:
create table html