Simple script to display results as ATOM feed

[John]

Then you probably want to use Jason's idea:

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

[mark]

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

[erick.thompson]

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

[mark]

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.

[erick.thompson]

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

[mark]

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

[erick.thompson]

Bingo! Thanks much for your help!

Erick

[erick.thompson]

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

[mark]

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

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