Hi All,
1) Can anyone using Oracle tell me how to get around referencing the &
symbol in oracle? I have an SQL script that is designed for users to run in
either Query Analyzer (SQL server) using ISQL (Sybase) like below:
INSERT INTO documents (doc_id, doc_text)
VALUES (1, "© Ektron 1999 & 2000, etc...")
Apparently whereever there is an &(ampersand) oracle expects a value and
prompts please enter value.
2) Does the Oracle ODBC driver prevent this from happening? The strings I am
dealing with contain formatted HTML and there will be a lot of & symbols.
Thanks,
Duane Boudreau,
eMPower Project Manager
Director, Web Technologies
Ektron, Inc.
http://www.ektron.com
5 Northern Blvd, Suite 6
Amherst, NH 03031
Tel: 603-594-0249 x114
Fax: 603-594-0258
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
