You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Kai Ponte <ka...@perfectreign.com> on 2008/05/28 20:11:29 UTC

Less Than Symbol

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?


-- 
kai
www.filesite.org || www.4thedadz.com || www.perfectreign.com
remember - a turn signal is a statement, not a request

Re: Less Than Symbol

Posted by Rick Hillegas <Ri...@Sun.COM>.

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?
>
>
>