Hi Lalanke, If you only need to use the numeric value for year then you can simply define regyear column as an int.
BR, Dinusha On Wed, Jun 24, 2015 at 11:57 PM, Sameera Medagammaddegedara < [email protected]> wrote: > Hi Lalanke, > > Could you please define the regyear column as DATETIME or TIMESTAMP and > try it again? > > > Thank You, > Sameera > > On Wed, Jun 24, 2015 at 5:03 PM, Lalanke Athauda <[email protected]> wrote: > >> Hi, >> I'm trying to get data from mysql database from a Jaggery app. >> I created a table like this, >> >> CREATE TABLE employee ( >> id INT AUTO_INCREMENT PRIMARY KEY, >> name VARCHAR(100) NULL, >> regyear *YEAR* >> ); >> >> And entered few records. >> >> Then I extracted the data in index.jag file from the db like this, >> >> <% >> var db = new Database("jdbc:mysql://localhost:3306/mydb", "root", >> "mypass"); >> >> var result = db.query("select * from employee"); >> >> print(result); >> %> >> >> I got this output, >> >> [{"id" : 1, "name" : "saman kumara", "regyear" : {}}, {"id" : 2, "name" : >> "nimal perera", "regyear" : {}}, {"id" : 3, "name" : "kapila kalinkga", >> "regyear" : {}}, {"id" : 4, "name" : "sarath senarath", "regyear" : {}}] >> >> Employee's id and name can be extracted, but I couldn't get the regyear >> value. It's empty. What might be the problem? >> >> Data type of `regyear` is `year`. Shall I have to take any further steps >> to solve this? >> >> I'm using Jaggery v1.0.0-SNAPSHOT_ALPHA3 and firefox browser. >> Thanks, >> >> -- >> Lalanke Athauda >> Software Engineer >> Mobile: 0772264301 >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > Sameera Medagammaddegedara > Software Engineer > > Contact: > Email: [email protected] > Mobile: + 94 077 255 3005 > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
