SQL help

Post Reply
User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

SQL help

Post by Thunderstone »




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



User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

SQL help

Post by Thunderstone »

Post Reply