Hi Kai,
Your insert statement runs fine for me: the complete html fragment is
successfully stored. Perhaps Netbeans is intercepting the <. You might
want to take your question to the Netbeans user list.
Here's what I see running the following ij script:
ij> create table notes
(
note varchar( 50 ),
contactid int
);
0 rows inserted/updated/deleted
ij> INSERT INTO NOTES (NOTE, CONTACTID) VALUES ('<html><br />', 43);
1 row inserted/updated/deleted
ij> select * from notes;
NOTE |CONTACTID
--------------------------------------------------------------
<html><br /> |43
1 row selected
Hope this helps you move the problem forward,
-Rick
Kai Ponte wrote:
I'm trying to save data to an embedded derby database. When I save to the
field, I noticed nothing was getting saved. I would get an execution
finished, but nothing saved.
Here's my query...
INSERT INTO DBUSER.NOTES (NOTE, CONTACTID) VALUES ('<html><br />', 43)
Running this from the database tool in Netbeans, I noticed that - if I remove
the less than symbol out of the line, it works fine.
INSERT INTO DBUSER.NOTES (NOTE, CONTACTID) VALUES ('html>br />', 43)
Is less than some special symbol?
