Oracle Problem [RESOLVED]
Posted: Mon Mar 20, 2006 12:55 am
Hi There
Oracle does a weird thing when trying to record a URL in a field e.g.
If I execute this query:
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
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');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