Page 1 of 1

Oracle Problem [RESOLVED]

Posted: Mon Mar 20, 2006 12:55 am
by thomas777neo
Hi There

Oracle does a weird thing when trying to record a URL in a field e.g.

If I execute this query:

Code: Select all

INSERT INTO table (id, url_field) VALUES (1, 'container.php?whattodo=test/example.php&right=workgroup');
It asks me to insert the the value for right:

So I type in workgroup.

What it actually records in the database looks like this:

container.php?whattodo=test/example.phpworkgroup=workgroup

So it renames my variable and removes the &

Any ideas to have it insert correctly?

EDIT: Use SET DEFINE OFF