Hi,
I have a profile as a base, and I combined another database with this profile using a script like this:
<DB=$sourceDB>
<SQL ROW "select * from html">
<DB=$targetDB>
<SQL NOVARS "insert into html values ($id, $Hash, $Size, $Visited, $Dlsecs, $Depth, $Url, $Title, $Body, $Keywords, $Description,
$Meta, $Catno, $Modified, $NextCheck, $Views, $Clicks, $CTR, $Pop, $MimeType, $Charset)">
</SQL>
</SQL>
</A>
Then I did a reindex so I would get a combination of two databases. The problem is I cannot delete URLs from the Edit/Delete URL option on the admin page. I want to delete all URLs matching a pattern like http://www.somesite.com/PrinterFriendly*, the goal is to get rid of any URL matching *PrinterFriendly*.
can I do this using a delete statement like
"texis -d E:\profile/db2 - s delete from html where URL like '*PrinterFriendly*'"?
Can this be done in a command window, or do I have a write a script to do this? Thanks!
I have a profile as a base, and I combined another database with this profile using a script like this:
<DB=$sourceDB>
<SQL ROW "select * from html">
<DB=$targetDB>
<SQL NOVARS "insert into html values ($id, $Hash, $Size, $Visited, $Dlsecs, $Depth, $Url, $Title, $Body, $Keywords, $Description,
$Meta, $Catno, $Modified, $NextCheck, $Views, $Clicks, $CTR, $Pop, $MimeType, $Charset)">
</SQL>
</SQL>
</A>
Then I did a reindex so I would get a combination of two databases. The problem is I cannot delete URLs from the Edit/Delete URL option on the admin page. I want to delete all URLs matching a pattern like http://www.somesite.com/PrinterFriendly*, the goal is to get rid of any URL matching *PrinterFriendly*.
can I do this using a delete statement like
"texis -d E:\profile/db2 - s delete from html where URL like '*PrinterFriendly*'"?
Can this be done in a command window, or do I have a write a script to do this? Thanks!