Updating URL field in dB

[RB]

I am specifying port ":81" in the url when I initiate the walk. I assume the dB will be created with urls that also contain port ":81" in the url. Therefore I want to "clean" the url field in the database to remove the ":81" instring so search defaults to port ":80"

I have commercial webinator, how do I update the dB field to do this?

Thanks in advance, your help is greatly appreciated.

[mark]

You need to write a small vortex script to perform the update. Something like:

<script language=vortex>
<db=/PATH/TO/YOUR/DATABASE>
<timeout=-1></timeout>
<a name=main>
<sql row "update html set Url=Url-':81'"></sql>
<sql row "update refs set Url=Url-':81', Ref=Ref-':81'"></sql>
</a>
</script>