Re: MS SQL 2000 database setup for snort with snortdb-extra (osql syntax issues?)

[todb () planb-security net]

John McCash wrote:

> The issues seem to be with the escaped apostrophe, the colon, and the use
> of the word 'Manager'. Does anyone know the proper way to structure these
> lines for mssql?

In Microsoft SQL 2000, use two apostrophes to represent a literal
apostrophe, like: 'Plus Five''s MUMPS'. (Unlike MySQL, backslashes won't
work.)

There shouldn't be any problem with any other character or phrase,
provided it's all contained in apostrohpe delimiters. Fix that and your
other problems should disappear.

-- 
Tod



-------------------------------------------------------
This SF.net email is sponsored by: The Robotic Monkeys at ThinkGeek
For a limited time only, get FREE Ground shipping on all orders of $35
or more. Hurry up and shop folks, this offer expires April 30th!
http://www.thinkgeek.com/freeshipping/?cpg=12297
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users