Thunderstone Support Forums

I would like to delete a couple of documents from my database but the names contain words with ' (apostrophes) in them. How do I reference these documents in a gw command? When I use gw -d- -s "delete from html where Url='www.url.com/data/noah's' it generates a syntax error.

Anyone have anythoughts about this. I don't have a lot of control over the file names that get put onto this server, so I kind of need to figure something out.

Dan

Double up the apostrophes within constants:

gw -d- -s "delete from html where Url='www.url.com/data/noah''s'