• Global community
    • Language:
      • Deutsch
      • English
      • EspaƱol
      • FranƧais
      • PortuguĆŖs
  • ę—„ęœ¬čŖžć‚³ćƒŸćƒ„ćƒ‹ćƒ†ć‚£
    Dedicated community for Japanese speakers
  • ķ•œźµ­ ģ»¤ė®¤ė‹ˆķ‹°
    Dedicated community for Korean speakers
Exit
0

Changing value of Param

Explorer ,
Feb 22, 2013 Feb 22, 2013

Copy link to clipboard

Copied

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!

TOPICS
Reporting

Views

729

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Sep 17, 2013 Sep 17, 2013

Copy link to clipboard

Copied

LATEST

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation