Re: JESS: insert data into database in JESS

2007-12-18 Thread Barlianti Vavorita
hello, thanks for the help, now i can successfully insert my data into database. before it, i have tried like this (without str-cat and without store it in some variable first) and it didnt work: (while (?result next) (?statement execute "insert into test (persen) values('"(?result getString y)"

Re: JESS: insert data into database in JESS

2007-12-17 Thread Wolfgang Laun
And there is the body of the while loop: (while (?result next) (?statement execute "insert into test (persen) values (?result getString y)")) which looks strange to me, as the string literal contains (presumably) some SQL statement, where the embedded Jess "(?result getString y)" may

Re: JESS: insert data into database in JESS

2007-12-17 Thread Ernest Friedman-Hill
A QueryResult is like an Iterator. It has a sort of "cursor" inside, and calling "next()" advances that cursor. When the cursor gets to the end, then the Iterator can't be used anymore and must be discarded. In your example below, you use the QueryResult to loop over the results and print t

JESS: insert data into database in JESS

2007-12-17 Thread Barlianti Vavorita
hello, can i insert data to database through JESS? i want to insert data on working memory to the database. first i used defquery to choose data which i want to insert into database. i have tried to select data in database with JESS and i can do it successfully. but why when i tried to insert dat