Date Help

[2005 IR Help]

By: Josh Batchelor - djcrazysk8er

Date Help

2004-03-05 22:02

I have racked my brain, and I cannot figure this out. I am passing in 2 dates the start date and teh end date. They are in this format 03-05-2004. Now I want to use it in the sql, but when I try the date shows up as Thu Mar.... Here is my XML any help would be great.

 

<parameter name="EntryDate" class="java.util.Date">

<parameterDescription><![CDATA[Please enter an entry date]]></parameterDescription>

<defaultValueExpression><![CDATA[new java.sql.Date()]]></defaultValueExpression>

</parameter>

<parameter name="EndDate" class="java.util.Date">

<parameterDescription><![CDATA[Please enter an end date]]></parameterDescription>

<defaultValueExpression><![CDATA[new java.sql.Date()]]></defaultValueExpression>

</parameter>

<queryString><![CDATA[sELECT

images.description,

images.costs,

customer_info.entryDate,

sessionorders.id,

stores.store_name,

stores.store_code

FROM

customer_info

INNER JOIN sessionorders ON (customer_info.session_id = sessionorders.session_id)

INNER JOIN images ON (sessionorders.id = images.id)

INNER JOIN stores ON (customer_info.store_number = stores.store_id)

WHERE

sessionorders.is_completed = 1

AND $P!{EntryDate} <= customer_info.entryDate

AND customer_info.entryDate <=$P!{EndDate}

 

GROUP BY sessionorders.id]]></queryString>

 

 

 

 

By: David Lim - aberrant80

RE: Date Help

2004-03-06 21:54

don't know about every1 else, but i just used a DateFormat.

 

 

 

 

By: Teodor Danciu - teodord

RE: Date Help

2004-03-07 00:32

 

Hi,

 

Do not use the $P!{} syntax, because it includes

your dates in the query converted as Strings and you

don't want that.

You just want to pass them as parameters to your

query and you should use the $P{} syntax.

 

I hope this helps.

Teodor

 

 

 

 

 

By: Giuseppe Bressan - gusbress

RE: Date Help

2004-12-14 06:14

I have thi query:

"SELECT tdipendenti.*

FROM tdipendenti INNER JOIN...

...

WHERE (tscadenzedipendenti.SCDPFINE >= $P{DATA}"

and

"<parameter name="DATA" isForPrompting="false" class="java.sql.Date"/>"

but when i try to compile have this error:

"java.lang.NullPointerException ????at?dori.jasper.engine.design.JRVerifier.verifyQuery(JRVerifier.java:373) ????at?dori.jasper.engine.design.JRVerifier.verifyDesign(JRVerifier.java:171)...."

 

where is my error?