Page 1 of 1

delete Domains

Posted: Fri Feb 16, 2001 1:41 pm
by Tobias
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.

delete Domains

Posted: Fri Feb 16, 2001 2:00 pm
by mark
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.

delete Domains

Posted: Fri Feb 16, 2001 6:34 pm
by Tobias
I try it with this procedure :

<a name=loeschen>
<!-- the $txt-variable is the name of the Domain -->
<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?

delete Domains

Posted: Sat Feb 17, 2001 8:55 am
by bart
This discussion belongs in the Webinator group, not the Vortex group.

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