Skip to Content
0
Former Member
Sep 25, 2008 at 11:52 AM

Error while search by date

27 Views

hai

below method triggering but getting error,

i not declare any CHAR in any where...

but i assigning the date attribute but it showing error as iam using CHAR.

i think in dictionary table filed is the date datatype.

it is cause may be not matching the sql date and webdynpro date .

my assume is it write, tell me what i need to do .

that is not matching the error is:

"SELECT * FROM "TASK_DETAILS" WHERE "TASK_RECEIPT_DATE" = '2008-09-24' ORDER BY 1,2" contains the semantics error[s]: - 1:34 - type check error: the left hand side >>"TASK_RECEIPT_DATE"<< (DATE) and the right hand side >>'2008-09-24'<< (CHAR) of a comparison operator are not comparable

the method code is as below

if (taskRecDate != null
			&& (taskStatus == null
				&& taskHanByBD == null
				&& taskNo == null
				&& taskType == null
				&& clientName == null)) {
		Date TaskRecDate = Date.valueOf(taskRecDate.toString());
			
	query = query + " TASK_RECEIPT_DATE = '" + TaskRecDate + "'";

			} else if (taskRecDate != null) {
			Date   TaskRecDate = Date.valueOf(taskRecDate.toString());
			
query = query + "AND TASK_RECEIPT_DATE = '" + TaskRecDate + "'";
			}
query = query + " ORDER BY TASK_NUMBER, TASK_TYPE";