This is a migrated thread and some comments may be shown as answers.

SQL parameter "WHERE ... IN @param"

1 Answer 63 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Fridli Jacober
Top achievements
Rank 1
Fridli Jacober asked on 30 Aug 2010, 06:35 AM
Hi,
I'm trying to pass a list of guids to a report but it does not work (there are no results).
SELECT     [...]
FROM         [...]
WHERE     (Object_ID = @ObjectID) AND cast(Node_OrganisationID as varchar(40)) IN (@OrganisationList

the sql statement directly on the sql server works:
SELECT [...]
FROM     [...]
WHERE   (Object_ID = '4c10e1f9-288c-441d-827d-cb2ca8bf85ac') AND cast(Node_OrganisationID as varchar(40)) IN ('83E37722-61A0-4780-8F4C-00D39FB6AA92','BB85E950-3BC4-4A2A-B413-791730D58A5D',[...])

'83E37722-61A0-4780-8F4C-00D39FB6AA92','BB85E950-3BC4-4A2A-B413-791730D58A5D' Does not seem to be the correct syntax to pass the guids to the parameter in telerik. Can you help me with the correct syntax?

Thanks

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 30 Aug 2010, 09:57 PM
Hello Roland Meier,

Generally this is impossible with the ADO.NET functionality (see discussion here). The good news is that such possibility is already implemented by Telerik Reporting and will be available in the upcoming SP1.

Greetings,
Peter
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
General Discussions
Asked by
Fridli Jacober
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or