variable in @ComSpec

[Wingens]

Hi I am trying to run a command from @ComSpec with a Variable in the syntax.

 

At the moment is this mycode:

RunWait(@ComSpec & " /c " & 'c:\bfretail\mysql\bin\mysql.exe -u"root" -p"*******" -h"localhost" -e"select count(*) from sessie where ss_datum >= ''2015-01-01'';" -Dbnfdta > C:\Temp\sessies.txt', "", @SW_HIDE)

Where I want to edit the command to automaticly find the year minus 1 like this:

Global $YEAR = @YEAR - 1

RunWait(@ComSpec & " /c " & 'c:\bfretail\mysql\bin\mysql.exe -u"root" -p"*******" -h"localhost" -e"select count(*) from betaling where bl_datum >=' & $YEAR & '-01-01'';" -Dbnfdta > C:\Temp\betaalregels.txt', "", @SW_HIDE)

But how do i create the right command syntax to use this?

[TheDcoder]

I believe that this is easier:

RunWait(@ComSpec & " /c " & 'c:\bfretail\mysql\bin\mysql.exe -u"root" -p"*******" -h"localhost" -e"select count(*) from betaling where bl_datum >=' & (@YEAR - 1) & '-01-01'';" -Dbnfdta > C:\Temp\betaalregels.txt', "", @SW_HIDE)

 

[Jos]

Assume you are having issues with what you posted?

When you need single quotes around the date, you are missing  the start single quote. Guess this should work:

RunWait(@ComSpec & " /c " & 'c:\bfretail\mysql\bin\mysql.exe -u"root" -p"*******" -h"localhost" -e"select count(*) from betaling where bl_datum >=''' & $YEAR & '-01-01'';" -Dbnfdta > C:\Temp\betaalregels.txt', "", @SW_HIDE)

Jos