Hello,
i am connecting to a Microsoft SQL Server Data Source and have defined @url_data with the defined url parameter textbox.
The query i use is:
IF @url_data != ''
SELECT
C.PERSNR, C.NAME, C.FIRSTNAME,
C.ADDRESS, C.ZIPCODE, C.CITY, C.COUNTRY, DATEBIRTH, DATE_IN, DATE_OUT, D.SHORT_1 as afdeling, C.USER08 AS email_intern, PHOTO
FROM curric c
JOIN PT_USERS p ON p.PERSNR IS NOT NULL AND c.PERSNR = p.PERSNR
join DEPART D ON D.DEPART = C.DEPART
WHERE C.FIRSTNAME LIKE '%' + @url_data + '%'
ELSE
SELECT
C.PERSNR, C.NAME, C.FIRSTNAME,
C.ADDRESS, C.ZIPCODE, C.CITY, C.COUNTRY, DATEBIRTH, DATE_IN, DATE_OUT, D.SHORT_1 as afdeling, C.USER08 AS email_intern, PHOTO
FROM curric c
JOIN PT_USERS p ON p.PERSNR IS NOT NULL AND c.PERSNR = p.PERSNR
join DEPART D ON D.DEPART = C.DEPART
but the result i getis a error telling me that @urldata isnt defiened
There was an error executing the data source: There is an error in your SQL at line 0: The parameterized query '(@PortalID int,@TabID int,@ModuleID int,@UserID int,@url_data nv' expects the parameter '@url_data', which was not supplied.
Could someone please help me. May be a broblem in the connector?
using the local database no problems, connecting to a other datasource errors in @url
thanks in advantage
Stefan