I have the following search script (very simple).
<script language=vortex>
<a name=main>
<?xml version="1.0" encoding="utf-8"?>
<result>
<DB = "">
<sql ROW SKIP=$skip MAX=10 "select Title, Description, Url from AccessAsia.html
where Title\Keywords\Body likep $q">
<result>
<title>$Title</title>
<link href="$Url" />
<summary>$Description</summary>
</result>
</sql>
<results>
</a>
</script>
The problem is, the search always defaults to the testdb, and complains about linear searches.
When setting up Webinator, I set up a profile/database, and now I'm trying to get the profile/database to apply to the search script above. It doesn't seem to work, regardless of what value I set to DB.
How do I correctly set the profile/database for a query?
Thanks,
Erick
<script language=vortex>
<a name=main>
<?xml version="1.0" encoding="utf-8"?>
<result>
<DB = "">
<sql ROW SKIP=$skip MAX=10 "select Title, Description, Url from AccessAsia.html
where Title\Keywords\Body likep $q">
<result>
<title>$Title</title>
<link href="$Url" />
<summary>$Description</summary>
</result>
</sql>
<results>
</a>
</script>
The problem is, the search always defaults to the testdb, and complains about linear searches.
When setting up Webinator, I set up a profile/database, and now I'm trying to get the profile/database to apply to the search script above. It doesn't seem to work, regardless of what value I set to DB.
How do I correctly set the profile/database for a query?
Thanks,
Erick