Skip to main content
Inspiring
February 22, 2013
Question

Changing value of Param

  • February 22, 2013
  • 1 reply
  • 797 views

I have a report that passes a date (time stamp) to a subreport. Sometimes the date being passed is  null (or an empty string) and the report . When this happens get an "Incompatible java.lang.String value assigned to parameter GradDate1 in the ColdFusionReport dataset.". I want to change the value of the Param being passed to current date.  Where and How can I change the date in the parama being passed. I've tried many things (functions, in the query, etc) and can't get anything to work. We are on CF 9. Please help!

This topic has been closed for replies.

1 reply

EddieLotter
Inspiring
September 17, 2013

You could handle this in your SQL query, for example:

select

isnull(nmedu.graduated, Date()) as graduated

from nmedu, institut

Check your database documentation for the supported syntax.