What I ment was that the string: "this doesn't work" contains an ' wich is forbidden, because SQL interprets the string as "This doesn" and can't understand the rest of it and therefore generates an error...
------------
Paul at 3/2/01 9:10:33 AM
INSERT into table1
Set field1
value 'i am a string'
------------
Charlie at 3/2/01 9:07:46 AM
The Query:
INSERT INTO Table1
VALUE('this doesn't work'
How can I Insert strings like the one above, into my database?
use double quotes for your insert and not single quote.
the string value can have a single quote
-MAK
------------
Charlie at 3/2/01 10:09:39 AM
What I ment was that the string: "this doesn't work" contains an ' wich is forbidden, because SQL interprets the string as "This doesn" and can't understand the rest of it and therefore generates an error...
------------
Paul at 3/2/01 9:10:33 AM
INSERT into table1
Set field1
value 'i am a string'
------------
Charlie at 3/2/01 9:07:46 AM
The Query:
INSERT INTO Table1
VALUE('this doesn't work'
How can I Insert strings like the one above, into my database?