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, PHOTObut 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?

thanks in advantage

Stefan

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