Welcome Guest Search | Active Topics | Members | Log In | Register

[WO 4.5] Is WebORB supports DATETIME type in findBySql method ? Options · View
Christophe
Posted: Wednesday, October 17, 2012 12:34:59 AM

Rank: Apprentice Coder
Groups: Member

Joined: 2/22/2012
Posts: 46
Points: -262
Location: France
Hi,

WEBORB INFO gives me an error with my sql syntax (MySQLSyntaxErrorException) when I use DATETIME type condition (2012-10-17 16:17:06)
My SQL string (used with findBySql method) looks like this : "SELECT * FROM myDocumentsTable WHERE creationDate >"+lastConnectionDateTime;
The "creationDate" column is of type DATETIME in my database.

However, my query works when I use a DATE type condition without time (2012-10-17).

Is WebORB supports DATETIME type or only DATE ?

Thanks in advance for your help,

Regards,

Christophe
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

YAFVision Theme Created by Jaben Cargman (Tiny Gecko)
Powered by Yet Another Forum.net version 1.9.1.8 (NET v4.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.
This page was generated in 0.216 seconds.