[BUG] MSSQL Safe SQL Parameter Not Working
Author: alexwijoyoCreated Jul 16, 2024Updated Jul 23, 2024
Labelsbug
Description
When I run query using safe SQL parameter, I got Incorrect syntax near '?'.
Steps to reproduce
- Create Safe parameterized select statement using MSSQL Resource
- Click on Save
- Clic on Run
- You will get run action error: mssql: Incorrect syntax near '?'.
- Sent SQL: exec sp_executesql N'select der.* from DailyExchangeRate der where der.SrcCurrencyId<>''USD'' and Date between ? and ?',N'@p1 nvarchar(max),@p2 nvarchar(max)',@p1=N'',@p2=N''
- Should be: exec sp_executesql N'select der.* from DailyExchangeRate der where der.SrcCurrencyId<>''USD'' and Date between @p1 and @p2',N'@p1 nvarchar(10),@p2 nvarchar(10)',@p1=N'2024-03-01',@p2=N'2024-07-31'
Version
self-host
ILLA Builder Version
latest
Browser
No response
Operating System
- macOS
- Windows
- Linux
Additional Information
No response
Source: illacloud/illa-builder