The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
Options

Macro using dates for SQL

ecdbertecdbert Member Posts: 21 Maven
Hi:
I'm trying to use a macro with date in an SQL statement but I'm getting an error from the SQL side. Here is part of the SQL statement: 
Declare @fDate date, @tdate date , @processingdate date, @lag int =%{lag}
SET @fDate =%{themonth}

error message is "Operand type clash: int is incompatible with date."

How do I resolve this?

Best Answer

  • Options
    ecdbertecdbert Member Posts: 21 Maven
    Solution Accepted
    UPDATE: I've resolved this by using 'concat' to add single quotes before and after the macro value in a 'Generate Macro' operator.

Answers

  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    Hi,

    that's a way to do it.

    You can also add the single quotes inside the SQL string if you are not using the prepare functionality.

    To make sure that you're not adding SQL injection vulnerabilities, you should use the "prepare statement" setting and enter your variable parameters in the form. Then RapidMiner will care for the correct quoting.

    Regards,
    Balázs
Sign In or Register to comment.