delete Domains

Tobias · Post by **Tobias** » Fri Feb 16, 2001 1:41 pm

Hallo,
I write a Vortex script to delete Domains from my Webinator Database.
This script lies on this link :
http://www.terris.de/webinator/versuchloesch1.txt

The running script is :
http://www.terris.de/cgi-bin/texis/webi ... uchloesch1

I have a problem with the Exec prompt. When I start the gw-Befehl in a telnet-session, it runs normal and the domain is deleted.
But if I ran it over the vortex script then the domain is not deleted.
What did I wrong?
Sorry about that bad english.

Post by **mark** » Fri Feb 16, 2001 2:00 pm

The exec'd background processes are probably getting killed when the cgi script finishes. You probably don't want background exec anyhow. You probably want sequential execution.

That said, you don't need to exec from vortex to perform sql operations. It would be MUCH simpler to perform the SQL directly within vortex. See http://www.thunderstone.com/site/vortexman/node35.html
Just make sure you do <apicp allinear 1> to allow your REX.

Tobias · Post by **Tobias** » Fri Feb 16, 2001 6:34 pm

I try it with this procedure :

<a name=loeschen>

<apicp allinear 1>
<SQL NOVARS "delete from html where Url like $txt " >
</SQL>
<SQL NOVARS "delete from refs where Url like $txt " >
</SQL>
</a>

But after the run from this skript no domain will be deleted.
What can I do?

bart · Post by **bart** » Sat Feb 17, 2001 8:55 am

This discussion belongs in the Webinator group, not the Vortex group.

For the best results from tech support, please post to the correct location.