Integration of Vignette with Texis/Webinator

joshua_augustin
Posts: 4
Joined: Mon Apr 23, 2001 7:37 am

Integration of Vignette with Texis/Webinator

Post by joshua_augustin »

Can anyone please provide me any small scripts that works as a bridge between Texis and the TCL(of the Vignette CMS) front end?
bart
Posts: 251
Joined: Wed Apr 26, 2000 12:42 am

Integration of Vignette with Texis/Webinator

Post by bart »

Vignette has developed an integration package for Thunderstone's Texis product.

Contact Andrew Coulson at Vignette's Advanced Solutions Team: 512-306-4730
joshua_augustin
Posts: 4
Joined: Mon Apr 23, 2001 7:37 am

Integration of Vignette with Texis/Webinator

Post by joshua_augustin »

hi bart,
does the thunderstone texis specifically give an intergration package using it's APIs with TCL or with any other third party product like BroadVision.
sorry for repeating the same question.
bart
Posts: 251
Joined: Wed Apr 26, 2000 12:42 am

Integration of Vignette with Texis/Webinator

Post by bart »

There are no direct APIs currently for TCL or Broadvision.

Vignettte used the 'C' API and Vortex to develop their interfaces to Texis.

The easiest way to communicate to Texis without resorting to the 'C' API is to set up RPC/Soap-ish calls via HTTP and Vortex. For the most part these are no-brainer apps to write in Vortex. A typical insert, delete, and search app that communicates in XML would only take about an hour to code in Vortex.
bart
Posts: 251
Joined: Wed Apr 26, 2000 12:42 am

Integration of Vignette with Texis/Webinator

Post by bart »

Here's a complete example XML search script that'll talk to a Webinator DB:

<script language=vortex>
<db=/usr/people/mosaic/htdocs/webinator/db>
<a name=main>
<sql max=10 row output=xml:ado
"select Title,Url,abstract(Body) Abs from html
where Title\Meta\Body likep $QUERY_STRING">
</sql>
</a>
</script>

to execute it via HTTP, you'd use a url like:

http://myserver/texis/xmlsearch?find+me
rkac
Posts: 7
Joined: Tue Jan 16, 2001 5:45 pm

Integration of Vignette with Texis/Webinator

Post by rkac »

Looks interesting.. but since the output is not a variable do you lose the capability of controlling query markup or abstract parameters?
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Integration of Vignette with Texis/Webinator

Post by John »

The SQL abstract function takes the same arguments as the Vortex function, so you have the same control. You can put a <capture></capture> around the <sql> which will put the output into $ret if you want to manipulate it further.
John Turnbull
Thunderstone Software
bart
Posts: 251
Joined: Wed Apr 26, 2000 12:42 am

Integration of Vignette with Texis/Webinator

Post by bart »

Rcak, If you want to do that kind of stuff then just use Vortex in its more common mode and just let it do it for you:

eg:

<sql max=10 row "select Title,Url,abstract(Body) Abs from html
where Title\Meta\Body likep $QUERY_STRING">

<a href=http://$Url>$Title</a>
<br>$Abs
<p>
</sql>
rkac
Posts: 7
Joined: Tue Jan 16, 2001 5:45 pm

Integration of Vignette with Texis/Webinator

Post by rkac »

We are attempting to write an xml interface and need the query string to be longer then default. When I attempt to use the abstract syntax I recieve a sql syntax error.

<!-- 015 /webinator/xmltest:10: Line 1: syntax error at "480" -->
<!-- 000 /webinator/xmltest:10: SQLPrepare() failed with -1 in the function prepntexis -->

What is the appropriate syntax?


Here is the code I used...

<sql max=10 row output=xml:ado
"select Title,Url,abstract(Body 480 smart $QUERY_STRING) Abs from html
where Title\Meta\Body likep $QUERY_STRING">
</sql>
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

Integration of Vignette with Texis/Webinator

Post by mark »

Post Reply